protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { Entity.TemplateMaster objConfigurationHead = new Entity.TemplateMaster(); if (hfPKEdit.Value != "0") { if (!(IsUpdate && Event.Find(x => x.EventName.Contains("Update")) != null)) { msg.GetMsg(this.Page, "TemplateMaster", "UR"); return; } objConfigurationHead.TemplateDropDownId = hfPKEdit.Value.ToInt32(); objConfigurationHead.EventId = Event.Find(x => x.EventName.Contains("Update")).EventId; } else { if (!(IsInsert && Event.Find(x => x.EventName.Contains("Insert")) != null)) { msg.GetMsg(this.Page, "TemplateMaster", "SR"); return; } objConfigurationHead.TemplateDropDownId = 0; objConfigurationHead.EventId = Event.Find(x => x.EventName.Contains("Insert")).EventId; } objConfigurationHead.TemplateDropdownName = txttemplatename.Text; objConfigurationHead.UserId = 0; objConfigurationHead.EventId = 0; objConfigurationHead.HostName = ""; objConfigurationHead.IpAddr = ""; objConfigurationHead.TransactionId = ""; int check = BAL.TemplateMastermgmt.AddUpdateTemplateMaster(objConfigurationHead); if (check > 0) { if (hfPKEdit.Value != "0") { msg.GetMsg(this.Page, "TemplateMaster", "U"); Clrscr(); GetListData(); } else { msg.GetMsg(this.Page, "TemplateMaster", "I"); Clrscr(); GetListData(); } } else if (check == -1) { msg.GetMsg(this.Page, "TemplateMaster", "AE"); } else { msg.GetMsg(this.Page, "TemplateMaster", "E"); } } }
public void FillTemplateMasterParams(SqlParameterCollection parameters, Entity.TemplateMaster Entity) { parameters.AddWithValue("@TemplateDropDownId", Entity.TemplateDropDownId); parameters.AddWithValue("@TemplateDropdownName", Entity.TemplateDropdownName); //parameters.AddWithValue("@CreatedBy", Entity.CreatedBy); parameters.AddWithValue("@UserId", Entity.UserId); parameters.AddWithValue("@HostName", Entity.HostName); parameters.AddWithValue("@IpAddr", Entity.IpAddr); parameters.AddWithValue("@EventId", Entity.EventId); parameters.AddWithValue("@TransactionId", Entity.TransactionId); }
public virtual int AddUpdateTemplateMaster(Entity.TemplateMaster Entity) { SqlCommand cmdInsert = new SqlCommand(); cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.CommandTimeout = 0; cmdInsert.CommandText = "dbo.AddUpdateTemplateMaster"; this.FillTemplateMasterParams(cmdInsert.Parameters, Entity); int res = this.ExecuteNonQuery(cmdInsert); base.ForceCloseConnection(cmdInsert); return(res); }
public virtual List <Entity.TemplateMaster> GetTemplateMasterData(int Id, int IsActive) { List <Entity.TemplateMaster> lstConfigurationHead = new List <Entity.TemplateMaster>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.Get_TemplateMasterData"; cmdSelect.Parameters.AddWithValue("@Id", Id); cmdSelect.Parameters.AddWithValue("@IsActive", IsActive); SqlDataReader dr = this.ExecuteDataReader(cmdSelect); while (dr.Read()) { Entity.TemplateMaster objConfigurationHead = new Entity.TemplateMaster(); lstConfigurationHead.Add(objConfigurationHead); this.FillEntityTemplateData(dr, objConfigurationHead, 0); } base.ForceCloseConnection(cmdSelect); return(lstConfigurationHead); }
protected void FillEntityTemplateData(IDataReader dr, Entity.TemplateMaster ObjConfigurationHead, int Type) { ObjConfigurationHead.TemplateDropDownId = GetFieldInt(dr, "TemplateDropDownId"); ObjConfigurationHead.TemplateDropdownName = GetField(dr, "TemplateDropdownName"); }
public static int AddUpdateTemplateMaster(Entity.TemplateMaster Entity) { return(new DAL.TemplateMasterSQL().AddUpdateTemplateMaster(Entity)); }