public string GetPrimarySalesParameters()
{
StringBuilder strContent = new StringBuilder();
try
{
DataControl.CurrentInfo objCurInfo = new CurrentInfo();
DataControl.BLProduct objProduct = new BLProduct();
List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel> lstParam = new List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel>();
lstParam = (List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel>)objProduct.GetAllPSParameters(objCurInfo.GetCompanyCode());
strContent.Append("<table class='table table-striped'><thead><tr>");
// strContent.Append("<td><input type='checkbox' name='chkSelectAll' onclick='fnSelectAll();' /> </td>");
strContent.Append("<td>Edit</td><td>Change Staus</td><td>Parameter Name</td><td>Parameter Column Name</td><td>Status</td>");
strContent.Append("</tr></thead>");
if (lstParam.Count > 0)
{
var lstParam1 = lstParam.AsEnumerable().Where(x => x.Record_Status == "1").ToList();
foreach (MVCModels.HiDoctor_Master.PrimarySalesParametersModel item in lstParam1)
{
strContent.Append("<tr>");
//<td><input type='checkbox' name='chkSelect' value='" + item.Parameter_Code + "' /> </td>");
strContent.Append("<td><a href='#' onclick='fnEditParam(\"" + item.Parameter_Code + "\",\""
+ item.Parameter_Name + "\",\"" + item.Param_Column_Name + "\",\""
+ item.Flag + "\");'>Edit</a></td>");
strContent.Append("<td><a href='#' onclick='fnChangeParamStatus(\""
+ item.Parameter_Code + "\",\"" + item.Record_Status + "\");'>Change Status</a></td>");
strContent.Append("<td>" + item.Parameter_Name + "</td>");
strContent.Append("<td>" + item.Param_Column_Name + "</td>");
if (item.Record_Status == "1")
{
strContent.Append("<td>Enabled</td>");
}
else
{
strContent.Append("<td>Disabled</td>");
}
strContent.Append("</tr>");
}
var lstParam2 = lstParam.AsEnumerable().Where(x => x.Record_Status == "0").ToList();
foreach (MVCModels.HiDoctor_Master.PrimarySalesParametersModel item in lstParam2)
{
strContent.Append("<tr>");
//<td><input type='checkbox' name='chkSelect' value='" + item.Parameter_Code + "' /> </td>");
strContent.Append("<td><a href='#' onclick='fnEditParam(\"" + item.Parameter_Code + "\",\""
+ item.Parameter_Name + "\",\"" + item.Param_Column_Name + "\",\""
+ item.Flag + "\");'>Edit</a></td>");
strContent.Append("<td><a href='#' onclick='fnChangeParamStatus(\""
+ item.Parameter_Code + "\",\"" + item.Record_Status + "\");'>Change Status</a></td>");
strContent.Append("<td>" + item.Parameter_Name + "</td>");
strContent.Append("<td>" + item.Param_Column_Name + "</td>");
if (item.Record_Status == "1")
{
strContent.Append("<td>Enabled</td>");
}
else
{
strContent.Append("<td>Disabled</td>");
}
strContent.Append("</tr>");
}
}
strContent.Append("</table>");
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
}
return(strContent.ToString());
}
public string InsertPSParameter(string parameterName, string parameterCode, string mode, string status, string flag, string columnName)
{
string result = string.Empty;
try
{
DataControl.CurrentInfo objCurInfo = new CurrentInfo();
DataControl.BLProduct objProduct = new BLProduct();
List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel> lstCheckParam = new List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel>();
lstCheckParam = (List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel>)objProduct.GetAllPSParameters(objCurInfo.GetCompanyCode());
if ("INSERT" == mode.ToUpper())
{
var fileterd = lstCheckParam.AsEnumerable().Where(z => z.Param_Column_Name.ToUpper() == columnName.ToUpper()).ToList();
if (fileterd.Count > 0)
{
result = "ERROR:Primary sales column name must be unique";
}
}
if ("EDIT" == mode.ToUpper())
{
var fileterd = lstCheckParam.AsEnumerable().Where(z => z.Param_Column_Name.ToUpper() == columnName.ToUpper()).ToList();
if (fileterd.Count > 0)
{
if (fileterd[0].Parameter_Code != parameterCode)
{
result = "ERROR:Primary sales column name must be unique";
}
}
}
if (string.IsNullOrEmpty(result))
{
int rowsAffected = 0;
List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel> lstParam = new List <MVCModels.HiDoctor_Master.PrimarySalesParametersModel>();
MVCModels.HiDoctor_Master.PrimarySalesParametersModel objParam = new MVCModels.HiDoctor_Master.PrimarySalesParametersModel();
objParam.Parameter_Name = parameterName;
objParam.Parameter_Code = parameterCode;
objParam.Record_Status = status;
objParam.Param_Column_Name = columnName;
objParam.Flag = flag;
objParam.Company_Code = objCurInfo.GetCompanyCode();
lstParam.Add(objParam);
rowsAffected = objProduct.InsertPSParameters(objCurInfo.GetCompanyCode(), mode, lstParam);
if (rowsAffected > 0)
{
if (mode.ToUpper() == "INSERT")
{
result = "SUCCESS:Primary sales parameter added successfully";
}
else if (mode.ToUpper() == "EDIT")
{
result = "SUCCESS:Primary sales parameter updated successfully";
}
else
{
result = "SUCCESS:Primary sales parameter status chnaged successfully";
}
}
else
{
result = "ERROR:Primary sales parameter updation failed";
}
}
}
catch (Exception ex)
{
Dictionary <string, string> dicContext = new Dictionary <string, string>();
DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
}
return(result);
}