public string InsertProduct(FormCollection collection) { string effFrom = collection["EffectiveFrom"].ToString(); string effTo = collection["EffectiveTo"].ToString(); string competitorName = ""; if (collection["ProductTypeName"].ToString().ToUpper() == "COMPETITOR") { competitorName = collection["competitor"].ToString(); } else { competitorName = "NULL"; } if (!string.IsNullOrEmpty(effFrom)) { effFrom = effFrom.Split('/')[2] + "-" + effFrom.Split('/')[1] + "-" + effFrom.Split('/')[0]; // effFrom = Convert.ToDateTime(collection["EffectiveFrom"].ToString()).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(effTo)) { effTo = effTo.Split('/')[2] + "-" + effTo.Split('/')[1] + "-" + effTo.Split('/')[0]; // effTo = Convert.ToDateTime(collection["EffectiveTo"].ToString()).ToString("yyyy-MM-dd"); } string result = objData.InsertProduct("sp_sdInsertProduct", objCurInfo.GetCompanyCode(), collection["ProductName"].ToString(), collection["SpecialityCode"].ToString(), collection["BrandCode"].ToString(), collection["CategoryCode"].ToString(), collection["UOMTypeCode"].ToString(), collection["UOMCode"].ToString(), collection["ProductTypeCode"].ToString(), collection["ProductGroupCode"].ToString(), collection["ProductDesc"].ToString(), collection["ProductTypeName"].ToString(), collection["ProductShortName"].ToString(), collection["ProductCost"].ToString(), effFrom, effTo, collection["ProductCode"].ToString(), competitorName, collection["RefKey1"].ToString(), collection["RefKey2"].ToString(), objCurInfo.GetUserCode()); return(result.Trim().Length == 0 ? "SUCCESS" : result); }