public virtual System.Data.DataSet GetMaxUserIDByFormId(Int64 FormId) { List <Entity.FormFilling> lstConfigurationHead = new List <Entity.FormFilling>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.GetMaxUserIDByFormId"; cmdSelect.Parameters.AddWithValue("@FormId", FormId); return(BaseSQLManager.ExecuteDataset(cmdSelect)); }
public virtual System.Data.DataSet GetCascadingDropdown(string TamplateDropDownId) { List <Entity.FormFilling> lstConfigurationHead = new List <Entity.FormFilling>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.GetCascadingDropDownData"; cmdSelect.Parameters.AddWithValue("@TamplateDropDownId", TamplateDropDownId); return(BaseSQLManager.ExecuteDataset(cmdSelect)); }
public virtual System.Data.DataSet BindDropDownFromTemplateDropDownId(string TemplateDropDownId) { List <Entity.FormFilling> lstConfigurationHead = new List <Entity.FormFilling>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.LoadDropDownTemplateMasterId"; cmdSelect.Parameters.AddWithValue("@TemplateDropDownId", TemplateDropDownId); return(BaseSQLManager.ExecuteDataset(cmdSelect)); }
public virtual DataSet Get_Summary_Query_Builder_data(string Query_Builder_id) { List <Entity.ConfigurationHead> lstConfigurationHead = new List <Entity.ConfigurationHead>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.Get_Summary_Query_Builder"; cmdSelect.Parameters.AddWithValue("@table_id ", Query_Builder_id); return(BaseSQLManager.ExecuteDataset(cmdSelect)); }
public virtual DataSet GetGridQueryData(string ddlQueryName) { List <Entity.ConfigurationHead> lstConfigurationHead = new List <Entity.ConfigurationHead>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.GetQueryFormData"; cmdSelect.Parameters.AddWithValue("@QueryMasterName", ddlQueryName); return(BaseSQLManager.ExecuteDataset(cmdSelect)); }
public virtual DataTable GetFormComponentData(int Id, int IsActive) { DataTable dt = new DataTable(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.GetComponentMasterData"; cmdSelect.Parameters.AddWithValue("@Id", Id); cmdSelect.Parameters.AddWithValue("@IsActive", IsActive); return(BaseSQLManager.ExecuteDataTable(cmdSelect)); }
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); }
public virtual DataSet Delete_Summary_QueryMaster_Data(string QueryMasterId) { SqlCommand cmdDelete = new SqlCommand(); cmdDelete.CommandType = CommandType.StoredProcedure; cmdDelete.CommandTimeout = 0; cmdDelete.CommandText = "dbo.Delete_SummaryQueryMaster_Data"; cmdDelete.Parameters.AddWithValue("@Query_Summary_Builder_id", QueryMasterId); DataSet res = BaseSQLManager.ExecuteDataset(cmdDelete); base.ForceCloseConnection(cmdDelete); return(res); }
public virtual DataSet getFormFillingData(string FormID, DataTable DtFilterData) { List <Entity.ConfigurationHead> lstConfigurationHead = new List <Entity.ConfigurationHead>(); SqlCommand cmdSelect = new SqlCommand(); cmdSelect.CommandType = CommandType.StoredProcedure; cmdSelect.CommandTimeout = 0; cmdSelect.CommandText = "dbo.getFormFillingData"; cmdSelect.Parameters.AddWithValue("@FormID", FormID); cmdSelect.Parameters.AddWithValue("@Udt_FilterFormFillingTable", DtFilterData); return(BaseSQLManager.ExecuteDataset(cmdSelect)); }
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)); }