/// <summary>
/// Search function by department ID and Namne
/// </summary>
/// <param name="DepartmentID"></param>
/// <param name="SearchText"></param>
/// <param name="TenantID"></param>
/// <returns></returns>
public List <StoreFunctionModel> SearchStoreFunctionByDepartment(int departmentID, string SearchText, int tenantID)
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <StoreFunctionModel> funcationMasters = new List <StoreFunctionModel>();
try
{
conn.Open();
cmd.Connection = conn;
MySqlCommand cmd1 = new MySqlCommand("SP_SearchFunctionByDepartmentId", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Department_ID", departmentID);
cmd1.Parameters.AddWithValue("@FuncText", string.IsNullOrEmpty(SearchText) ? "" : SearchText.ToLower());
cmd1.Parameters.AddWithValue("@Tenant_ID", tenantID);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd1;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
StoreFunctionModel function = new StoreFunctionModel();
function.FunctionID = Convert.ToInt32(ds.Tables[0].Rows[i]["FunctionID"]);
function.FuncationName = Convert.ToString(ds.Tables[0].Rows[i]["FuncationName"]);
function.DepartmentID = departmentID;
function.TenantID = tenantID;
funcationMasters.Add(function);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
if (ds != null)
{
ds.Dispose();
}
}
return(funcationMasters);
}
public List <StoreFunctionModel> GetStoreFunctionList(int TenantID, int UserID)
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <StoreFunctionModel> users = new List <StoreFunctionModel>();
try
{
conn.Open();
cmd.Connection = conn;
MySqlCommand cmd1 = new MySqlCommand("SP_GetStoreUserFullName", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Tenant_ID", TenantID);
cmd1.Parameters.AddWithValue("@User_ID", UserID);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd1;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
StoreFunctionModel user = new StoreFunctionModel();
user.FunctionID = Convert.ToInt32(ds.Tables[0].Rows[i]["UserID"]);
user.FuncationName = Convert.ToString(ds.Tables[0].Rows[i]["FullName"]);
user.IsActive = Convert.ToBoolean(ds.Tables[0].Rows[i]["IsActive"]);
users.Add(user);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(users);
}
/// <summary>
/// Get Function By multiple DepartmentIDs
/// </summary>
/// <param name="DepartmentID"></param>
/// <returns></returns>
public List <StoreFunctionModel> GetStoreFunctionbyMultiDepartment(string DepartmentIds, int TenantID)
{
DataSet ds = new DataSet();
MySqlCommand cmd = new MySqlCommand();
List <StoreFunctionModel> funcationMasters = new List <StoreFunctionModel>();
try
{
conn.Open();
cmd.Connection = conn;
MySqlCommand cmd1 = new MySqlCommand("SP_getFunctionByMultipleDepartmentId", conn);
cmd1.CommandType = CommandType.StoredProcedure;
cmd1.Parameters.AddWithValue("@Department_ID", string.IsNullOrEmpty(DepartmentIds) ? "": DepartmentIds.TrimEnd(','));
cmd1.Parameters.AddWithValue("@Tenant_ID", TenantID);
MySqlDataAdapter da = new MySqlDataAdapter();
da.SelectCommand = cmd1;
da.Fill(ds);
if (ds != null && ds.Tables[0] != null)
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
StoreFunctionModel function = new StoreFunctionModel();
function.FunctionID = Convert.ToInt32(ds.Tables[0].Rows[i]["FunctionID"]);
function.FuncationName = Convert.ToString(ds.Tables[0].Rows[i]["FuncationName"]);
funcationMasters.Add(function);
}
}
}
catch (Exception)
{
throw;
}
finally
{
if (conn != null)
{
conn.Close();
}
}
return(funcationMasters);
}
