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