The sql code below will take the first character and then the rest of the character s from the space index.

john doe will be returned as jdoe.  can use any delimiter in charindex.  Add one to the int that charindex returns and the len(column) function to get the rest of the values.

substring([full name],1,1) + substring([full name],CHARINDEX (' ' ,[full name]) +1,len([full name])) [UserName]

Need to use product_id and not sku!  use sku to get item and then set product_id

one example of one item.

public string UpdateInventory(string sku, int inStock, string stkQty)
        {
            if (string.IsNullOrEmpty(this.SessionId))
                this.Login();

            try
            {
                string prodID = string.Empty ;
                catalogInventoryStockItemEntity ie = new catalogInventoryStockItemEntity();
               
                MagentoPushPullService.MagentoWebService.catalogInventoryStockItemUpdateEntity cisi = new catalogInventoryStockItemUpdateEntity();
                cisi.is_in_stock = inStock;
                cisi.qty = stkQty;
                cisi.is_in_stockSpecified = true;
               
// you can pass in more than one product at a time by setting/passing in an array of strings
                string[] item = new string[1] ;
                item[0] = sku;
               
                foreach (catalogInventoryStockItemEntity  sie in   magentoService.catalogInventoryStockItemList(this.SessionId,item))
                {
                    prodID = sie.product_id ;
                }

  // Update product by product id from StockItemList call
                int i;
                i = magentoService.catalogInventoryStockItemUpdate(this.SessionId, prodID, cisi);

                foreach (catalogInventoryStockItemEntity sie in magentoService.catalogInventoryStockItemList(this.SessionId, item))
                {
                    string tmp = sie.is_in_stock;
                }

              
                return "Success";
            }
            catch (Exception ex)
            {
                //TODO: Log the error               
                return "Error updating inventory";
            }
          
        }

using existing sql mail profile.

EXEC msdb.dbo.sp_send_dbmail

@profile_name = 'ReportsMail',

@recipients = @emailto,

@body = @body,

@blind_copy_recipients = 'add addresses here',

@subject = @subject;

quick and easy way to send email to many to addresses.

public static void SendMessageEmail(string eTO, string From, string Subject, string message, bool isHtml)

{

MailMessage msg = new MailMessage();

char split = Convert.ToChar(";");

string[] emTo = eTO.Split(split);

foreach (string toAdd in emTo)

{

msg.To.Add(toAdd);

}

msg.From = new MailAddress(From);

msg.Subject = Subject;

msg.Body = message;

msg.IsBodyHtml = isHtml;

SmtpClient client = new SmtpClient("mail.yourserver.com");

try

{client.Send(msg);}

catch (Exception exc) {//do something to handle error here }}

put this in web config file.

<configuration>
    <system.web>
        <httpRuntime maxRequestLength="4096" />
    </system.web>
</configuration>

length =  4,096 kilobytes (KB) (or 4MB)

When pulling records from sales_order, I discovered that the row_total field has values > 0 for lines with 100% discount! You must subtract discount_amount to get extended price.

this.ExtendedPrice = Convert.ToDecimal(item.row_total )-Convert.ToDecimal(item.discount_amount );

I have found this error is probably due to a dll not being registered on the target machine.

reg file below will add right click menu item to register or unregister files

create .reg file with the contents below and merge into the registry.

REGEDIT4

[HKEY_CLASSES_ROOT\.dll]
@="dllfile"

[HKEY_CLASSES_ROOT\.ocx]
@="ocxfile"

[HKEY_CLASSES_ROOT\.olb]
@="olbfile"

[HKEY_CLASSES_ROOT\.exe]
@="exefile"

[HKEY_CLASSES_ROOT\dllfile\shell\Register\command]
@="regsvr32.exe \"%1\""

[HKEY_CLASSES_ROOT\ocxfile\shell\Register\command]
@="regsvr32.exe \"%1\""

[HKEY_CLASSES_ROOT\olbfile\shell\Register\command]
@="regsvr32.exe \"%1\""

[HKEY_CLASSES_ROOT\exefile\shell\Register\command]
@="\"%1\" /register"

[HKEY_CLASSES_ROOT\dllfile\shell\Register (Silent)\command]
@="regsvr32.exe /s \"%1\""

[HKEY_CLASSES_ROOT\ocxfile\shell\Register (Silent)\command]
@="regsvr32.exe /s \"%1\""

[HKEY_CLASSES_ROOT\olbfile\shell\Register (Silent)\command]
@="regsvr32.exe /s \"%1\""

[HKEY_CLASSES_ROOT\dllfile\shell\UnRegister\command]
@="regsvr32.exe /u \"%1\""

[HKEY_CLASSES_ROOT\ocxfile\shell\UnRegister\command]
@="regsvr32.exe /u \"%1\""

[HKEY_CLASSES_ROOT\olbfile\shell\UnRegister\command]
@="regsvr32.exe /u \"%1\""

[HKEY_CLASSES_ROOT\exefile\shell\UnRegister\command]
@="\"%1\" /unregister"

[HKEY_CLASSES_ROOT\dllfile\shell\UnRegister (Silent)\command]
@="regsvr32.exe /u /s \"%1\""

[HKEY_CLASSES_ROOT\ocxfile\shell\UnRegister (Silent)\command]
@="regsvr32.exe /u /s \"%1\""

[HKEY_CLASSES_ROOT\olbfile\shell\UnRegister (Silent)\command]
@="regsvr32.exe /u /s \"%1\""

Used to create 3 level TreeView.

protected void PopNav() {

tvNav.Nodes.Clear();

DAL dLayer = new DAL();

DataSet ds = dLayer.GetNavCategory();

ds.Relations.Add("CatToProd", ds.Tables["Cat"].Columns["Category"], ds.Tables["Prod"].Columns["Category"]);

ds.Relations.Add("ProdToFile", ds.Tables["Prod"].Columns["productid"], ds.Tables["FileTypes"].Columns["productid"]);

TreeNode nodeCat;

TreeNode nodeProd;

TreeNode nodeFile;

foreach (DataRow rowCat in ds.Tables["Cat"].Rows)

{

nodeCat = new TreeNode();

nodeCat.Expanded = false;

nodeCat.SelectAction = TreeNodeSelectAction.Expand;

nodeCat.Text = rowCat["Category"].ToString();

tvNav.Nodes.Add(nodeCat);

foreach (DataRow rowProd in rowCat.GetChildRows("CatToProd"))

{

nodeProd = new TreeNode();

nodeProd.Expanded = false;

nodeProd.Text = rowProd["ShortDescription"].ToString();

nodeProd.Value = rowProd["productid"].ToString();

nodeCat.ChildNodes.Add(nodeProd);

foreach (DataRow rowFileType in rowProd.GetChildRows("ProdToFile"))

{

nodeFile = new TreeNode();

nodeFile.Text = rowFileType["FileType"].ToString();

nodeFile.Value = rowFileType["productid"].ToString();

nodeProd.ChildNodes.Add(nodeFile);

}

}

}

}

///////////////DAL method

public DataSet GetNavCategory()

{

DataSet ds = new DataSet();

SqlConnection cn = new SqlConnection(ConfigurationManager.ConnectionStrings["RenewLifeConnStr"].ConnectionString);

string sql = @"dbo.GetAllCategories";

string sqlProd = @"dbo.GetAllCategoryDescriptions";

string sqlFileType = @"dbo.GetAllFileTypesByProduct";

SqlDataAdapter daCat = new SqlDataAdapter(sql, cn);

SqlDataAdapter daProd = new SqlDataAdapter(sqlProd, cn);

SqlDataAdapter daFileType = new SqlDataAdapter(sqlFileType, cn);

daCat.SelectCommand.CommandType = CommandType.StoredProcedure;

daCat.SelectCommand.CommandTimeout = 20000;

daProd.SelectCommand.CommandType = CommandType.StoredProcedure;

daProd.SelectCommand.CommandTimeout = 20000;

daFileType.SelectCommand.CommandType = CommandType.StoredProcedure;

daFileType.SelectCommand.CommandTimeout = 20000;

using (cn)

{

cn.Open();

daCat.Fill(ds, "Cat");

daProd.Fill(ds, "Prod");

daFileType.Fill(ds, "FileTypes");

}

return ds;

}