protected void FillEntityRegexData(IDataReader dr, Entity.RegexMasterEntitycs ObjRegex, int Type) { ObjRegex.RegexId = GetFieldInt(dr, "regexMasterId"); ObjRegex.ValidationName = GetField(dr, "RegexValidationName"); ObjRegex.ValidationExp = GetField(dr, "RegexvalidationExpression"); ObjRegex.ErrMsg = GetField(dr, "ErrorMessage"); }
protected void btnSave_Click(object sender, EventArgs e) { if (Page.IsValid) { Entity.RegexMasterEntitycs objregex = new Entity.RegexMasterEntitycs(); if (hfPKEdit.Value != "0") { if (!(IsUpdate && Event.Find(x => x.EventName.Contains("Update")) != null)) { msg.GetMsg(this.Page, "RegexMaster", "UR"); return; } objregex.RegexId = hfPKEdit.Value.ToInt32(); objregex.EventId = Event.Find(x => x.EventName.Contains("Update")).EventId; } else { if (!(IsInsert && Event.Find(x => x.EventName.Contains("Insert")) != null)) { msg.GetMsg(this.Page, "RegexMaster", "SR"); return; } objregex.RegexId = 0; objregex.EventId = Event.Find(x => x.EventName.Contains("Insert")).EventId; } objregex.ValidationName = txtValidationName.Text; objregex.ErrMsg = txtErrMsg.Text; objregex.ValidationExp = txtValidationExp.Text; objregex.HostName = ""; objregex.IpAddr = ""; objregex.UserId = 0; objregex.TransactionId = ""; objregex.EventId = 0; objregex.Isdelete = false; int check = BAL.FormMastermgmt.AddUpdateRegexMaster(objregex); if (check > 0) { if (hfPKEdit.Value != "1") { msg.GetMsg(this.Page, "RegexMastre", "U"); Clrscr(); GetListData(); GetSetClass(false, true); } else { msg.GetMsg(this.Page, "RegexMastre", "I"); Clrscr(); GetListData(); } } } }
public void FillRegexParamsDetails(SqlParameterCollection parameters, Entity.RegexMasterEntitycs Entity) { parameters.AddWithValue("@RegexMasterId", Entity.RegexId); parameters.AddWithValue("@ValidationName", Entity.ValidationName); parameters.AddWithValue("@ErrMsg", Entity.ErrMsg); parameters.AddWithValue("@ValidationExp", Entity.ValidationExp); parameters.AddWithValue("@IpAddr", Entity.IpAddr); parameters.AddWithValue("@HostName", Entity.HostName); parameters.AddWithValue("@UserId", Entity.UserId); parameters.AddWithValue("@TransactionId", Entity.TransactionId); parameters.AddWithValue("@EventId", Entity.EventId); parameters.AddWithValue("@IsDeleted", Entity.Isdelete); }
public virtual int AddUpdateRegexMaster(Entity.RegexMasterEntitycs Entity) { SqlCommand cmdInsert = new SqlCommand(); cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.CommandTimeout = 0; cmdInsert.CommandText = "dbo.Insert_Update_RegexMasterDetails"; this.FillRegexParamsDetails(cmdInsert.Parameters, Entity); int res = this.ExecuteNonQuery(cmdInsert); base.ForceCloseConnection(cmdInsert); return(res); }
public virtual List <Entity.RegexMasterEntitycs> GetRegexMasterData(int Id) { List <Entity.RegexMasterEntitycs> lstConfigurationHead = new List <Entity.RegexMasterEntitycs>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.GetRegexMasterData"; cmdSelect.Parameters.AddWithValue("@Id", Id); SqlDataReader dr = this.ExecuteDataReader(cmdSelect); while (dr.Read()) { Entity.RegexMasterEntitycs objConfigurationHead = new Entity.RegexMasterEntitycs(); lstConfigurationHead.Add(objConfigurationHead); this.FillEntityRegexData(dr, objConfigurationHead, 0); } base.ForceCloseConnection(cmdSelect); return(lstConfigurationHead); }
public static int AddUpdateRegexMaster(Entity.RegexMasterEntitycs Entity) { return(new DAL.FormMasterSQL().AddUpdateRegexMaster(Entity)); }