protected void FillEntityTemplateData(IDataReader dr, Entity.ParameterMaster ObjConfigurationHead, int Type)
{
ObjConfigurationHead.ParameterId = GetFieldInt(dr, "ParameterId");
ObjConfigurationHead.ParameterName = GetField(dr, "ParameterName");
ObjConfigurationHead.BaseParameterName = GetField(dr, "BaseParameterName");
ObjConfigurationHead.CreateDate = GetField(dr, "CreateDate");
ObjConfigurationHead.TamplateDropDownId = GetFieldInt(dr, "TamplateDropDownId");
ObjConfigurationHead.BaseParameterId = GetFieldInt(dr, "BaseParameterId");
ObjConfigurationHead.MainParameter = GetFieldInt(dr, "MainTemplateParameter");
}
private void InsertUpdateCascadingDropdownRecord()
{
Entity.ParameterMaster obj = new Entity.ParameterMaster();
if (hfPKEdit.Value != "0")
{
if (!(IsUpdate && Event.Find(x => x.EventName.Contains("Update")) != null))
{
msg.GetMsg(this.Page, "TemplateDataBinding", "UR");
return;
}
if (!System.Text.RegularExpressions.Regex.IsMatch(txttemplate.Text, "^[a-zA-Z ]"))
{
msg.GetMsg(this.Page, "TemplateDataBinding", "ANC");
txttemplate.Text.Remove(txttemplate.Text.Length - 1);
return;
}
obj.ParameterId = hfPKEdit.Value.ToInt32();
obj.EventId = Event.Find(x => x.EventName.Contains("Update")).EventId;
}
else
{
if (!(IsInsert && Event.Find(x => x.EventName.Contains("Insert")) != null))
{
msg.GetMsg(this.Page, "TemplateDataBinding", "SR");
return;
}
obj.ParameterId = 0;
obj.EventId = Event.Find(x => x.EventName.Contains("Insert")).EventId;
}
//child
obj.BaseParameterId = Convert.ToInt32(ddlBaseTemplateValue.SelectedValue);
//Subchile for Entry
obj.TamplateDropDownId = Convert.ToInt32(ddlTemplate.SelectedValue);
obj.UserId = 0;
obj.DropdownValue = txttemplate.Text.Trim();
DataSet dsget = BAL.ParameterMasterMGMT.InsertDropdownEntry(obj);
if (dsget.Tables [0].Rows.Count > 0)
{
msg.GetMsg(this.Page, dsget.Tables[0].Rows[0]["msg"].ToString(), "");
btnCascadingReset_Click(null, null);
}
}
public System.Data.DataSet InsertFormFillingMaster(Entity.ParameterMaster obj)
{
List <Entity.FormFilling> lstConfigurationHead = new List <Entity.FormFilling>();
SqlCommand cmdSelect = new SqlCommand();
cmdSelect.CommandType = CommandType.StoredProcedure;
cmdSelect.CommandTimeout = 0;
cmdSelect.CommandText = "Insert_ms_FormFillingMaster";
cmdSelect.Parameters.AddWithValue("@TemplateDropDownId", obj.TamplateDropDownId);
cmdSelect.Parameters.AddWithValue("@BaseParameterId", obj.BaseParameterId);
cmdSelect.Parameters.AddWithValue("@DropdownValue", obj.DropdownValue);
cmdSelect.Parameters.AddWithValue("@CreatedBy", obj.UserId);
cmdSelect.Parameters.AddWithValue("@TransactionId", obj.TransactionId);
cmdSelect.Parameters.AddWithValue("@EventId", obj.EventId);
cmdSelect.Parameters.AddWithValue("@IpAddr", obj.IpAddr);
cmdSelect.Parameters.AddWithValue("@ParameterId", obj.ParameterId);
return(BaseSQLManager.ExecuteDataset(cmdSelect));
}
private void InsertNormalRecord()
{
Entity.ParameterMaster obj = new Entity.ParameterMaster();
if (hfPKEdit.Value != "0")
{
if (!(IsUpdate && Event.Find(x => x.EventName.Contains("Update")) != null))
{
msg.GetMsg(this.Page, "TemplateDataBinding", "UR");
return;
}
if (!System.Text.RegularExpressions.Regex.IsMatch(txtDropdownValue.Text, "^[a-zA-Z ]"))
{
msg.GetMsg(this.Page, "TemplateDataBinding", "ANC");
txttemplate.Text.Remove(txtDropdownValue.Text.Length - 1);
return;
}
obj.ParameterId = hfPKEdit.Value.ToInt32();
obj.EventId = Event.Find(x => x.EventName.Contains("Update")).EventId;
}
else
{
if (!(IsInsert && Event.Find(x => x.EventName.Contains("Insert")) != null))
{
msg.GetMsg(this.Page, "TemplateDataBinding", "SR");
return;
}
obj.ParameterId = 0;
obj.EventId = Event.Find(x => x.EventName.Contains("Insert")).EventId;
}
obj.TamplateDropDownId = Convert.ToInt32(ddlTamplateMaster.SelectedValue);
obj.BaseParameterId = 0;
obj.EventId = Event.Find(x => x.EventName.Contains("Insert")).EventId;
//obj.UserId = Convert.ToInt32(Session["UserId"].ToString());
obj.UserId = 0;
obj.DropdownValue = txtDropdownValue.Text;
obj.IpAddr = "";
DataSet dsget = BAL.ParameterMasterMGMT.InsertDropdownEntry(obj);
msg.GetMsg(this.Page, dsget.Tables[0].Rows[0]["msg"].ToString(), "");
ddlTamplateMaster.SelectedIndex = -1;
txtDropdownValue.Text = string.Empty;
}
public virtual List <Entity.ParameterMaster> GetFormFillingMaster(int parameterId)
{
List <Entity.ParameterMaster> lstConfigurationHead = new List <Entity.ParameterMaster>();
SqlCommand cmdSelect = new SqlCommand();
cmdSelect.CommandType = CommandType.StoredProcedure;
cmdSelect.CommandTimeout = 0;
cmdSelect.CommandText = "Get_Ms_DropdownBindingData";
cmdSelect.Parameters.AddWithValue("@ParameterId", parameterId);
SqlDataReader dr = this.ExecuteDataReader(cmdSelect);
while (dr.Read())
{
Entity.ParameterMaster objConfigurationHead = new Entity.ParameterMaster();
lstConfigurationHead.Add(objConfigurationHead);
this.FillEntityTemplateData(dr, objConfigurationHead, 0);
}
base.ForceCloseConnection(cmdSelect);
return(lstConfigurationHead);
}
public static DataSet InsertDropdownEntry(Entity.ParameterMaster obj)
{
DAL.InsertParameterMaster VPM = new DAL.InsertParameterMaster();
return(VPM.InsertFormFillingMaster(obj));
}
