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