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));
}
