public virtual DataSet AddUpdateFormFilling(Entity.FormFilling Entity) { SqlCommand cmdInsert = new SqlCommand(); cmdInsert.CommandType = CommandType.StoredProcedure; cmdInsert.CommandTimeout = 0; cmdInsert.CommandText = "dbo.AddUpdateFormFilling"; this.FillParamsDetails(cmdInsert.Parameters, Entity); DataSet res = BaseSQLManager.ExecuteDataset(cmdInsert); base.ForceCloseConnection(cmdInsert); return(res); }
protected void FillEntityControlByForm(IDataReader dr, Entity.FormFilling ObjConfigurationHead, int Type) { ObjConfigurationHead.ConfigurationHeadName = GetField(dr, "ConfigurationHeadName"); ObjConfigurationHead.ConfigurationHeadId = GetFieldInt64(dr, "ConfigurationHeadId"); ObjConfigurationHead.HeadNote = GetField(dr, "HeadNote"); ObjConfigurationHead.InputTypeId = GetFieldInt(dr, "InputTypeId"); ObjConfigurationHead.InputType = GetField(dr, "InputType"); ObjConfigurationHead.MinInputValue = GetField(dr, "MinInputValue"); ObjConfigurationHead.MaxInputValue = GetField(dr, "MaxInputValue"); ObjConfigurationHead.IsCompulsaryEntry = GetFieldBool(dr, "IsCompulsaryEntry"); ObjConfigurationHead.TemplateDropdownMasterId = GetFieldInt64(dr, "TemplateDropdownMasterId"); ObjConfigurationHead.TemplateDropdownName = GetField(dr, "TemplateDropdownName"); }
protected void btnSearch_Click(object sender, EventArgs e) { Entity.FormFilling objFormFilling = new Entity.FormFilling(); objFormFilling.MinInputValue = "0"; DataSet ds = BAL.FormFillingmgmt.GetSearchingControlByForm(ddlFormname.SelectedValue.ToInt32()); DataTable qt = ds.Tables[1]; DataTable st = ds.Tables[0]; objFormFilling.dt = GetQulaifyingHeadData(sectionSerach, qt, st); GetListData(objFormFilling.dt); GetSetClass(false, true); }
public void FillParamsDetails(SqlParameterCollection parameters, Entity.FormFilling Entity) { parameters.AddWithValue("@FormId", Entity.FormId); parameters.AddWithValue("@dt", Entity.dt); 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("@Isupdate", Entity.Isupdate); parameters.AddWithValue("@SeqId", Entity.SeqId); parameters.AddWithValue("@DistCode", Entity.DistCode); parameters.AddWithValue("@TalCode", Entity.TalCode); parameters.AddWithValue("@OfficeId", Entity.OfficeId); parameters.AddWithValue("@OtherSession", Entity.OtherSession); }
public static System.Data.DataSet AddUpdateFormFilling(Entity.FormFilling Entity) { return(new DAL.FormFillingSQL().AddUpdateFormFilling(Entity)); }
protected void btnSave_Click(object sender, EventArgs e) { Entity.FormFilling objFormFilling = new Entity.FormFilling(); objFormFilling.MinInputValue = "0"; DataSet ds = BAL.FormFillingmgmt.GetControlByForm(ddlFormname.SelectedValue.ToInt32(), Session["SeqId"].ToString().ToInt64(), 0); DataTable qt = ds.Tables[1]; DataTable st = ds.Tables[0]; objFormFilling.dt = GetQulaifyingHeadData(sectionLev1, qt, st); if (objFormFilling.dt.Rows.Count == 0) { msg.GetMsg(this.Page, "Please configure atleast one control.", ""); return; } objFormFilling.FormId = ddlFormname.SelectedValue.ToInt32(); objFormFilling.HostName = ""; objFormFilling.IpAddr = ""; objFormFilling.SeqId = Session["SeqId"].ToString().ToInt64(); if (btnSave.Text.ToString().ToLower() == "update") { objFormFilling.Isupdate = true; } else { objFormFilling.Isupdate = false; } objFormFilling.DistCode = Session["DistCode"].ToString(); objFormFilling.TalCode = Session["TalCode"].ToString(); objFormFilling.OfficeId = Session["OfficeId"].ToString(); objFormFilling.OtherSession = Session["OtherSession"].ToString(); DataSet check = BAL.FormFillingmgmt.AddUpdateFormFilling(objFormFilling); if (check.Tables.Count > 0) { for (int i = 0; i < check.Tables.Count; i++) { if (check.Tables[i].Rows.Count > 0) { if (Convert.ToInt32(check.Tables[i].Rows[0]["RetVal"]) == 1) { msg.GetMsg(this.Page, check.Tables[i].Rows[0]["RetMsg"].ToString(), ""); clrscr(); GetSetClass(false, true); btnSearch_Click(null, null); } else if (Convert.ToInt32(check.Tables[i].Rows[0]["RetVal"]) == 2) { DataSet ds1 = BAL.FormFillingmgmt.GetMaxUserIDByFormId(ddlFormname.SelectedValue.ToInt64()); //Session["SeqId"] = ds1.Tables[0].Rows[0]["USERID"].ToString().ToInt64() + 1; clrscr(); GetSetClass(false, true); msg.GetMsg(this.Page, check.Tables[i].Rows[0]["RetMsg"].ToString(), ""); btnSearch_Click(null, null); } else if (Convert.ToInt32(check.Tables[i].Rows[0]["RetVal"]) == -1) { msg.GetMsg(this.Page, check.Tables[i].Rows[0]["RetMsg"].ToString(), ""); } else if (Convert.ToInt32(check.Tables[i].Rows[0]["RetVal"]) == -3) { msg.GetMsg(this.Page, check.Tables[i].Rows[0]["RetMsg"].ToString(), ""); } } } } else { msg.GetMsg(this.Page, "ConfigurationForm", "E"); } }