protected void FillEntityFormData(IDataReader dr, Entity.FormMaster ObjConfigurationHead, int Type)
{
ObjConfigurationHead.FormId = GetFieldInt(dr, "FormId");
ObjConfigurationHead.FormTitle = GetField(dr, "FormTitle");
ObjConfigurationHead.FormName = GetField(dr, "FormName");
ObjConfigurationHead.Remarks = GetField(dr, "Remarks");
ObjConfigurationHead.Is_Freez = GetField(dr, "IsFreez");
}
public virtual DataSet FreezFormMaster(Entity.FormMaster Entity)
{
SqlCommand cmdInsert = new SqlCommand();
cmdInsert.CommandType = CommandType.StoredProcedure;
cmdInsert.CommandTimeout = 0;
cmdInsert.CommandText = "dbo.UpdateFreezdata";
this.FillParamsFreezDetails(cmdInsert.Parameters, Entity);
DataSet res = this.ExecuteDataSet1(cmdInsert);
base.ForceCloseConnection(cmdInsert);
return(res);
}
public virtual int AddSessionLog(Entity.FormMaster Entity)
{
SqlCommand cmdInsert = new SqlCommand();
cmdInsert.CommandType = CommandType.StoredProcedure;
cmdInsert.CommandTimeout = 0;
cmdInsert.CommandText = "dbo.Sp_Insert_Session_Login";
this.FillSessionLogParamsDetails(cmdInsert.Parameters, Entity);
int res = this.ExecuteNonQuery(cmdInsert);
base.ForceCloseConnection(cmdInsert);
return(res);
}
public void FillParamsDetails(SqlParameterCollection parameters, Entity.FormMaster Entity)
{
parameters.AddWithValue("@FormId", Entity.FormId);
parameters.AddWithValue("@FormName", Entity.FormName);
parameters.AddWithValue("@FormTitle", Entity.FormTitle);
parameters.AddWithValue("@Remarks", Entity.Remarks);
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);
parameters.AddWithValue("@RefFormId", Entity.RefFormId);
parameters.AddWithValue("@DtComponent", Entity.DtComponent);
}
public void FillSessionLogParamsDetails(SqlParameterCollection parameters, Entity.FormMaster Entity)
{
parameters.AddWithValue("@FormId", Entity.FormId);
parameters.AddWithValue("@DistName", Entity.DistName);
parameters.AddWithValue("@TalName", Entity.TalName);
parameters.AddWithValue("@OfficeName", Entity.OfficeName);
parameters.AddWithValue("@OtherSession", Entity.OtherSession);
parameters.AddWithValue("@HostName", Entity.HostName);
parameters.AddWithValue("@IpAddr", Entity.IpAddr);
parameters.AddWithValue("@userName", Entity.UserName);
parameters.AddWithValue("@userid", Entity.UserId);
parameters.AddWithValue("@RoleName", Entity.RoleName);
parameters.AddWithValue("@RoleId", Entity.Roleid);
}
public virtual List <Entity.FormMaster> GetFormMasterData(int Id, int IsActive)
{
List <Entity.FormMaster> lstConfigurationHead = new List <Entity.FormMaster>();
SqlCommand cmdSelect = new SqlCommand();
cmdSelect.CommandType = CommandType.StoredProcedure;
cmdSelect.CommandTimeout = 0;
cmdSelect.CommandText = "dbo.GetFormMasterData";
cmdSelect.Parameters.AddWithValue("@Id", Id);
cmdSelect.Parameters.AddWithValue("@IsActive", IsActive);
SqlDataReader dr = this.ExecuteDataReader(cmdSelect);
while (dr.Read())
{
Entity.FormMaster objConfigurationHead = new Entity.FormMaster();
lstConfigurationHead.Add(objConfigurationHead);
this.FillEntityFormData(dr, objConfigurationHead, 0);
}
base.ForceCloseConnection(cmdSelect);
return(lstConfigurationHead);
}
protected void lstvFormMaster_ItemCommand(object sender, ListViewCommandEventArgs e)
{
if (e.CommandName == "EditData")
{
EditData(e.CommandArgument.ToString());
}
if (e.CommandName == "FreezData")
{
HiddenField Form_ID = e.Item.FindControl("hfDKId") as HiddenField;
Entity.FormMaster objConfigurationHead = new Entity.FormMaster();
objConfigurationHead.FormId = Form_ID.Value.ToInt32();
string FreezValue = e.CommandArgument.ToString();
if (FreezValue == "Freez")
{
objConfigurationHead.Is_Freez = "1";
}
else
{
objConfigurationHead.Is_Freez = "0";
}
DataSet check = BAL.FormMastermgmt.FreezFormMaster(objConfigurationHead);
if (check.Tables[0].Rows.Count > 0)
{
//msg.GetMsg(this.Page, check.Tables[0].Rows[0]["Msg"].ToString(), "");
string String = check.Tables[0].Rows[0]["Msg"].ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('" + String + "');location.href = 'FormMaster.aspx';", true);
}
else if (check.Tables[1].Rows.Count > 0)
{
//msg.GetMsg(this.Page, check.Tables[1].Rows[0]["Msg"].ToString(), "");
string String = check.Tables[1].Rows[0]["Msg"].ToString();
ScriptManager.RegisterStartupScript(this, this.GetType(), "message", "alert('" + String + "');location.href = 'FormMaster.aspx';", true);
}
GetListData();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
//String SSOAppID = _encrDecrpOBJ.Encrypt(ConfigurationManager.AppSettings["SSOAppID"]);
//and then Pass value in query strinng
EncryptDecryptQueryString _encrDecrpOBJ = new EncryptDecryptQueryString();
Entity.FormMaster objConfigurationHead = new Entity.FormMaster();
//string converted = Request.QueryString.ToString();//Request.QueryString.ToString().Replace("/", "");
////converted = converted.Replace("+", "");
//converted = converted.Replace("%", "");
//string qrystring = converted, ConfigurationManager.AppSettings["GenericKey"]);
if (Request.QueryString["OfficeId"] != null && Request.QueryString["OfficeId"] != string.Empty)
{
Session["OfficeId"] = Request.QueryString["OfficeId"].ToString();
objConfigurationHead.OfficeName = Session["OfficeId"].ToString();
}
if (Request.QueryString["DistCode"] != null && Request.QueryString["DistCode"] != string.Empty)
{
Session["DistCode"] = Request.QueryString["DistCode"].ToString();
objConfigurationHead.DistName = Session["DistCode"].ToString();
}
if (Request.QueryString["TalCode"] != null && Request.QueryString["TalCode"] != string.Empty)
{
Session["TalCode"] = Request.QueryString["TalCode"].ToString();
objConfigurationHead.TalName = Session["TalCode"].ToString();
}
if (Request.QueryString["OtherSession"] != null && Request.QueryString["OtherSession"] != string.Empty)
{
Session["OtherSession"] = Request.QueryString["OtherSession"].ToString();
objConfigurationHead.OtherSession = Session["OtherSession"].ToString();
}
if (Request.QueryString["Formid"] != null && Request.QueryString["Formid"] != string.Empty)
{
Session["Formid"] = Request.QueryString["Formid"].ToString();
Session["MenuId"] = Session["Formid"];
objConfigurationHead.FormId = Convert.ToInt32(Session["Formid"]);
}
if (Request.QueryString["RoleId"] != null && Request.QueryString["RoleId"] != string.Empty)
{
Session["RoleId"] = Request.QueryString["RoleId"].ToString();
objConfigurationHead.Roleid = Session["RoleId"].ToString();
}
if (Request.QueryString["RoleName"] != null && Request.QueryString["RoleName"] != string.Empty)
{
Session["RoleName"] = Request.QueryString["RoleName"].ToString();
objConfigurationHead.RoleName = Session["RoleName"].ToString();
}
if (Request.QueryString["UserId"] != null && Request.QueryString["UserId"] != string.Empty)
{
Session["UserId"] = Request.QueryString["UserId"].ToString();
objConfigurationHead.UserId = Convert.ToInt32(Session["UserId"].ToString());
}
if (Request.QueryString["UserName"] != null && Request.QueryString["UserName"] != string.Empty)
{
Session["UserName"] = Request.QueryString["UserName"].ToString();
objConfigurationHead.UserName = Session["UserName"].ToString();
}
int check = BAL.FormMastermgmt.AddSessionLog(objConfigurationHead);
if (check == 1)
{
Response.Redirect("Formfilling.aspx");
}
}
}
public void FillParamsFreezDetails(SqlParameterCollection parameters, Entity.FormMaster Entity)
{
parameters.AddWithValue("@IsFreez", Entity.Is_Freez);
parameters.AddWithValue("@Form_id", Entity.FormId);
}
protected void FillEntityComponentData(IDataReader dr, Entity.FormMaster ObjConfigurationHead, int Type)
{
ObjConfigurationHead.FormComponentMasterId = GetFieldInt(dr, "id");
ObjConfigurationHead.ComponentName = GetField(dr, "ComponentName");
ObjConfigurationHead.ComponentSeqNo = GetFieldDecimal(dr, "ComponentSeqNo");
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (Page.IsValid)
{
Entity.FormMaster objConfigurationHead = new Entity.FormMaster();
if (hfPKEdit.Value != "0")
{
if (!(IsUpdate && Event.Find(x => x.EventName.Contains("Update")) != null))
{
msg.GetMsg(this.Page, "FormMaster", "UR");
return;
}
objConfigurationHead.FormId = 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, "FormMaster", "SR");
return;
}
objConfigurationHead.FormId = 0;
objConfigurationHead.EventId = Event.Find(x => x.EventName.Contains("Insert")).EventId;
}
if (ViewState["dtData"] == null)
{
dt.Columns.Add("ComponentName");
dt.Columns.Add("SeqNo");
dt.Columns.Add("id");
DataRow dr = dt.NewRow();
dr[0] = txtFormName.Text;
dr[1] = 1;
dr[2] = 0;
dt.Rows.Add(dr);
ViewState["dtData"] = dt;
}
else
{
DataTable dt = (DataTable)ViewState["dtData"];
dt.Columns.Remove("Validationid");
ViewState["dtData"] = dt;
}
objConfigurationHead.DtComponent = (DataTable )ViewState["dtData"];
objConfigurationHead.FormName = txtFormName.Text;
objConfigurationHead.FormTitle = txtFormTitle.Text;
objConfigurationHead.Remarks = txtRemark.Text;
objConfigurationHead.HostName = "";
objConfigurationHead.IpAddr = "";
objConfigurationHead.UserId = 0;
objConfigurationHead.RefFormId = ddlFormname.SelectedValue.ToInt32();
int check = BAL.FormMastermgmt.AddUpdateFormMaster(objConfigurationHead);
if (check > 0)
{
if (hfPKEdit.Value != "0")
{
msg.GetMsg(this.Page, "FormMaster", "U");
Clrscr();
GetListData();
GetSetClass(false, true);
}
else
{
msg.GetMsg(this.Page, "FormMaster", "I");
Clrscr();
GetListData();
}
}
else if (check == -3)
{
msg.GetMsg(this.Page, "Record Freezed, You Can't Insert And Update.", "");
}
else if (check == -1)
{
msg.GetMsg(this.Page, "FormMaster", "AE");
}
else
{
msg.GetMsg(this.Page, "FormMaster", "E");
}
}
}
public static DataSet FreezFormMaster(Entity.FormMaster Entity)
{
return(new DAL.FormMasterSQL().FreezFormMaster(Entity));
}
public static int AddSessionLog(Entity.FormMaster Entity)
{
return(new DAL.FormMasterSQL().AddSessionLog(Entity));
}
public static int AddUpdateFormMaster(Entity.FormMaster Entity)
{
return(new DAL.FormMasterSQL().AddUpdateFormMaster(Entity));
}
