public ActionResult AddNewScript(PromoScript ps) { ActiveDirectoryWeb ad = new ActiveDirectoryWeb(); string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|'); ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]); try { string logI = HttpContext.User.Identity.Name; int ret = ScriptDataAccess.SaveNewScript(ps, logI.Split('\\').LastOrDefault()); if (ret > 0) { return(RedirectToAction("Index")); } else { ViewData["Err"] = "Script Template Already Exist!"; } } catch (Exception ex) { ViewData["Err"] = ex.Message; } return(View(ps)); }
public static int SaveNewScript(PromoScript ps, string userId) { using (SqlConnection scon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConn"].ConnectionString)) { if (scon.State == ConnectionState.Closed) { scon.Open(); } SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = scon; cmd.CommandText = "usp_InsertScript"; cmd.Parameters.AddWithValue("@ScriptCode", ps.ScriptTemplate); cmd.Parameters.AddWithValue("@ScriptName", string.IsNullOrEmpty(ps.ScriptName) ? "" : ps.ScriptName); cmd.Parameters.AddWithValue("@BiScriptCode", string.IsNullOrEmpty(ps.BiScriptCode) ? "" : ps.BiScriptCode); cmd.Parameters.AddWithValue("@Description", string.IsNullOrEmpty(ps.Description) ? "" : ps.Description); cmd.Parameters.AddWithValue("@CoreOfferSalesTax", string.IsNullOrEmpty(ps.CoreOfferSalesTax) ? "" : ps.CoreOfferSalesTax); cmd.Parameters.AddWithValue("@CrossSaleTax", string.IsNullOrEmpty(ps.CrossSalesTax) ? "" : ps.CrossSalesTax); cmd.Parameters.AddWithValue("@BrandCode", string.IsNullOrEmpty(ps.BrandCode) ? "" : ps.BrandCode); cmd.Parameters.AddWithValue("@UserId", userId); SqlParameter Result = new SqlParameter(); Result.ParameterName = "@Result"; Result.Direction = ParameterDirection.Output; Result.SqlDbType = SqlDbType.Int; cmd.Parameters.Add(Result); cmd.ExecuteNonQuery(); int ret = Convert.ToInt32(Result.Value); return(ret); } }
public static List <PromoScript> GetScripts() { List <PromoScript> retVal = new List <PromoScript>(); using (SqlConnection scon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConn"].ConnectionString)) { try { if (scon.State == ConnectionState.Closed) { scon.Open(); } SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.Text; cmd.Connection = scon; cmd.CommandText = "SELECT * FROM [Script] order by ScriptName"; SqlDataReader rdr = cmd.ExecuteReader(); while (rdr.Read()) { PromoScript sc = new PromoScript(); sc.ScriptTemplate = rdr["ScriptCode"].ToString(); sc.ScriptName = rdr["ScriptName"].ToString(); sc.BiScriptCode = rdr["BiScriptCode"].ToString(); sc.Description = rdr["Description"].ToString(); sc.CoreOfferSalesTax = rdr["CoreOfferSalesTax"].ToString(); sc.CrossSalesTax = rdr["CrossSaleTax"].ToString(); retVal.Add(sc); } } catch (Exception) { throw; } } return(retVal); }
public ActionResult EditScript(PromoScript ps, string OldScriptCode) { ActiveDirectoryWeb ad = new ActiveDirectoryWeb(); string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|'); ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]); string logI = HttpContext.User.Identity.Name; try { ScriptDataAccess.UpdateScript(ps, OldScriptCode, logI.Split('\\').LastOrDefault()); } catch { ViewBag.OldScriptCode = OldScriptCode; return(View(ps)); } return(RedirectToAction("Index")); }
public ActionResult EditScript(string tId) { ActiveDirectoryWeb ad = new ActiveDirectoryWeb(); string[] usr = ad.SearchActiveDirectory(HttpContext.User.Identity.Name).Split('|'); ViewBag.IsAdmin = DataAccess.AdminAccess(usr[1]); PromoScript ps = new PromoScript(); DataRow dr = ScriptDataAccess.GetScript(tId); ps.ScriptTemplate = dr["ScriptCode"].ToString(); ps.ScriptName = dr["ScriptName"].ToString(); ps.BiScriptCode = dr["BIScriptCode"].ToString(); ps.CoreOfferSalesTax = dr["CoreOfferSalesTax"].ToString(); ps.CrossSalesTax = dr["CrossSaleTax"].ToString(); ps.Description = dr["Description"].ToString(); ps.BrandCode = dr["BrandCode"].ToString(); ViewBag.OldScriptCode = dr["ScriptCode"].ToString(); ViewBag.BrandCode = new SelectList(ScriptDataAccess.GetBrands(), "BrandCode", "BrandName", ps.BrandCode); return(View(ps)); }
public static void UpdateScript(PromoScript ps, string oldScriptCode, string userId) { using (SqlConnection scon = new SqlConnection(ConfigurationManager.ConnectionStrings["SQLConn"].ConnectionString)) { if (scon.State == ConnectionState.Closed) { scon.Open(); } SqlCommand cmd = new SqlCommand(); cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = scon; cmd.CommandText = "usp_UpdateScript"; cmd.Parameters.AddWithValue("@ScriptCode", ps.ScriptTemplate); cmd.Parameters.AddWithValue("@ScriptName", string.IsNullOrEmpty(ps.ScriptName) ? "" : ps.ScriptName); cmd.Parameters.AddWithValue("@BiScriptCode", string.IsNullOrEmpty(ps.BiScriptCode) ? "" : ps.BiScriptCode); cmd.Parameters.AddWithValue("@Description", string.IsNullOrEmpty(ps.Description) ? "" : ps.Description); cmd.Parameters.AddWithValue("@CoreOfferSalesTax", string.IsNullOrEmpty(ps.CoreOfferSalesTax) ? "" : ps.CoreOfferSalesTax); cmd.Parameters.AddWithValue("@CrossSaleTax", string.IsNullOrEmpty(ps.CrossSalesTax) ? "" : ps.CrossSalesTax); cmd.Parameters.AddWithValue("@BrandCode", string.IsNullOrEmpty(ps.BrandCode) ? "" : ps.BrandCode); cmd.Parameters.AddWithValue("@UserId", userId); cmd.Parameters.AddWithValue("@OldScriptCode", oldScriptCode); cmd.ExecuteNonQuery(); } }