public object SetOrder()
{
string strReturn = "";
Data _objData = new Data();
try
{
// Creates Instance
SPData _objSPData = new SPData();
string cmdText = "SP_HDInsertPOBOrder";
// Set Command object.
SqlCommand command = new SqlCommand(cmdText);
command.CommandType = CommandType.StoredProcedure;
// Add the parameters to command object.
if (objOrder.orderAdd.lstHeader.Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_POB_Header", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_POB_Header");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_POB_Header", ParameterDirection.Input, SqlDbType.Structured, new DCROrderHeaderEnumurator(objOrder.orderAdd.lstHeader), "TVP_POB_Header");
}
if (objOrder.orderAdd.lstDetails.Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_POB_Details", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_POB_Details");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_POB_Details", ParameterDirection.Input, SqlDbType.Structured, new DCROrderDetailsEnumurator(objOrder.orderAdd.lstDetails), "TVP_POB_Details");
}
_objSPData.AddParamToSqlCommand(command, "@DCR_Status", ParameterDirection.Input, SqlDbType.VarChar, 30, "");
if (objOrder.orderAdd.lstHeader[0].Order_Id == -1)
{
_objSPData.AddParamToSqlCommand(command, "@DCR_Actual_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, DateTime.Now.Date.ToShortDateString());
}
else
{
_objSPData.AddParamToSqlCommand(command, "@DCR_Actual_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, objOrder.orderAdd.lstHeader[0].Order_Date);
}
//_objSPData.AddParamToSqlCommand(command, "@DCR_Visit_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, "");
_objSPData.AddParamToSqlCommand(command, "@Result", ParameterDirection.Output, SqlDbType.VarChar, 500, strReturn);
// Opens the connection.
_objData.OpenConnection(objOrder.orderInputs.Company_Code);
_objData.ExecuteNonQuery(command);
}
finally
{
_objData.CloseConnection();
}
return(strReturn);
}
// Insert order Header record.
public string InsertOTC(string companyCode, string orderId, string orderDate, string isSubmit, string custCode, string salesPersonCode
, string salesPersonName, string enterBy, string enterByRegion, string orderValue, string remarks, string refNumber, string dueDate)
{
SPData _objSPData = new SPData();
string result = "";
try
{
SqlCommand command = new SqlCommand(SP_mhdInsertOTCHeader);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@CustomerCode", ParameterDirection.Input, SqlDbType.VarChar, 30, custCode);
_objSPData.AddParamToSqlCommand(command, "@CustomerRegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, salesPersonCode);
_objSPData.AddParamToSqlCommand(command, "@SalesPersonName", ParameterDirection.Input, SqlDbType.VarChar, 30, salesPersonName);
_objSPData.AddParamToSqlCommand(command, "@SaleOrderDate", ParameterDirection.Input, SqlDbType.Date, 30, orderDate);
_objSPData.AddParamToSqlCommand(command, "@SaleOrderCode", ParameterDirection.Input, SqlDbType.VarChar, 30, orderId);
_objSPData.AddParamToSqlCommand(command, "@SaleOrderAmt", ParameterDirection.Input, SqlDbType.Decimal, 30, orderValue);
_objSPData.AddParamToSqlCommand(command, "@EnteredBy", ParameterDirection.Input, SqlDbType.VarChar, 30, enterBy);
_objSPData.AddParamToSqlCommand(command, "@RegionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, enterByRegion);
_objSPData.AddParamToSqlCommand(command, "@DeliveryDate", ParameterDirection.Input, SqlDbType.Date, 30, dueDate);
_objSPData.AddParamToSqlCommand(command, "@Remarks", ParameterDirection.Input, SqlDbType.VarChar, remarks.Length, remarks);
_objSPData.AddParamToSqlCommand(command, "@IsSubmit", ParameterDirection.Input, SqlDbType.Int, 3, isSubmit);
_objSPData.AddParamToSqlCommand(command, "@RefNumber", ParameterDirection.Input, SqlDbType.VarChar, 30, refNumber);
SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar);
returnValue.Direction = ParameterDirection.Output;
returnValue.Size = 500;
returnValue.Value = "";
command.Parameters.Add(returnValue);
_objData.OpenConnection(companyCode);
_objData.ExecuteNonQuery(command);
_objData.CloseConnection();
result = returnValue.Value.ToString();
return(result);
}
catch (Exception ex)
{
return("FAILURE:" + ex.Message);
}
}
public string FreezeTarget(FormCollection collection)
{
try
{
string qry = "EXEC SP_hdFreezeTarget '" + _objCurr.GetCompanyCode() + "','" + collection["TargetCode"].ToString() + "','" + collection["RegionCode"].ToString() + "','" + collection["TargetMonth"].ToString() + "'";
_objData.OpenConnection(_objCurr.GetCompanyCode());
{
_objData.ExecuteNonQuery(qry);
}
return("");
}
catch (Exception ex)
{
ErrorLog.LogError(ex, "FreezeTarget()");
return(ex.Message.ToString());
}
finally
{
_objData.CloseConnection();
}
}
public string SaveKYDInfo(string company_Code, IEnumerable <KYDModel> IlstKYDModel)
{
try
{
_objSPData = new SPData();
_objData = new Data();
string cmdText = SPHD_KYDSAVEDOCINFO;
SqlCommand command = new SqlCommand(cmdText);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, company_Code);
if (((List <KYDModel>)IlstKYDModel).Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@KYD_TEMP", ParameterDirection.Input, SqlDbType.Structured, null, KYD_TYPE_NAME);
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@KYD_TEMP", ParameterDirection.Input, SqlDbType.Structured, new KYDEnumurator(IlstKYDModel), KYD_TYPE_NAME);
}
SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar);
returnValue.Direction = ParameterDirection.Output;
returnValue.Size = 500;
command.Parameters.Add(returnValue);
_objData.OpenConnection(company_Code);
_objData.ExecuteNonQuery(command);
string result = command.Parameters["@Result"].Value.ToString();
_objData.CloseConnection();
// returns the list.
return(result);
}
catch
{
throw;
}
}
public void InsertRequest(string methodName, string data, string status, string message)
{
try
{
SqlCommand command = new SqlCommand(SP_HD_KANGLE_INSERTREQUEST);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@MethodName", ParameterDirection.Input, SqlDbType.VarChar, 0, methodName);
_objSPData.AddParamToSqlCommand(command, "@Data", ParameterDirection.Input, SqlDbType.VarChar, 0, data);
_objSPData.AddParamToSqlCommand(command, "@Status", ParameterDirection.Input, SqlDbType.VarChar, 0, status);
_objSPData.AddParamToSqlCommand(command, "@Message", ParameterDirection.Input, SqlDbType.VarChar, 0, message);
_ObjData.OpenConnection();
_ObjData.ExecuteNonQuery(command);
}
catch (Exception ex)
{
}
finally
{
_ObjData.CloseConnection();
}
}
public string ChangeStatus(string CompanyCode, string LeaveTypeCode, string status)
{
_objSPData = new SPData();
_objData = new Data();
string result = "";
try
{
SqlCommand command = new SqlCommand(SP_HD_ChangeStatusforLeaveType);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, CompanyCode);
_objSPData.AddParamToSqlCommand(command, "@LeaveTypeCode", ParameterDirection.Input, SqlDbType.VarChar, 30, LeaveTypeCode);
_objSPData.AddParamToSqlCommand(command, "@status", ParameterDirection.Input, SqlDbType.VarChar, 30, status);
_objData.OpenConnection(CompanyCode);
_objData.ExecuteNonQuery(command);
_objData.CloseConnection();
return(result);
}
catch (Exception ex)
{
throw ex;
}
}
public string ChangeStatus(FormCollection collection)
{
try
{
//Added DCR History details for Mobile
BLApproval _objApproval = new BLApproval();
DALApproval _objDALApproval = new DALApproval();
string leaveEntry = collection["LeaveValidation"].ToString();
string remarks = collection["Remarks"].ToString();
string status = collection["Status"].ToString();
string dcrCode = collection["DCRCode"].ToString();
string flag = collection["Flag"].ToString();
string leaveType = collection["LeaveTypeName"].ToString();
string userCode = collection["UserCode"].ToString();
string calcFields = collection["CalcFields"].ToString();
string DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK = collection["DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK"].ToString();
string dcr_Actual_Date = collection["DCR_Actual_Date"].ToString();
string twoActivityExpenseValidation = collection["twoActivityExpenseValidation"].ToString();
string fareDailyAllowance = collection["fareDailyAllowance"].ToString();
string calcFieldStatus = calcFields.ToUpper() == "APPLIED" ? "1" : "2";
string[] privValues;
// string leaveTypeName = "";
// bool isCurBalanceNeed = false;
// double dblLeaveBalance = 0.0;
string dcrStatus;
int CurrexpenseClaimValidation = 0;
privValues = leaveEntry.Split(',');
if (status == "0")
{
if (string.IsNullOrEmpty(remarks))
{
return("FAIL:Reason must be given for unapproval");
}
}
if (twoActivityExpenseValidation.ToUpper() != "NO" && fareDailyAllowance != "" && flag != "L" && status == "0")
{
string twoActivityDCRApproval = _objDALApproval.GetTwoActivityDCRApproval(dcrCode, flag, fareDailyAllowance);
objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
dcrStatus = (string)objData.ExecuteScalar("exec SP_hdGetDCRStatus '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "'");
}
if (dcrStatus == "2")
{
CurrexpenseClaimValidation = _objDALApproval.CheckExpenseClaim(_objCurrentInfo.GetCompanyCode(), userCode, dcrCode, flag, dcr_Actual_Date);
if (CurrexpenseClaimValidation > 0)
{
return("FAIL:You Cannot Unapprove the DCR-" + dcr_Actual_Date + " " + ((flag == "F") ? "Field" : ((flag == "A") ? "Attendace" : "Leave")) + " as the expenses are claimed in expenses claim");
}
string expenseClaimValidation = _objDALApproval.CheckDayExpenseClaim(dcrCode, flag);
if (expenseClaimValidation != "")
{
return("FAIL:You Cannot Unapprove the other DCR-" + expenseClaimValidation.Split('|')[0] + " " + ((expenseClaimValidation.Split('|')[1] == "F") ? "Field" : ((expenseClaimValidation.Split('|')[1] == "A") ? "Attendace" : "Leave")) + " as the expenses are claimed in expenses claim");
}
}
if (twoActivityDCRApproval != "")
{
string TwoActivitydcrCode = twoActivityDCRApproval.Split('|')[0];
string TwoActivityflag = twoActivityDCRApproval.Split('|')[1];
string TwoActivitydcrStatusOld = twoActivityDCRApproval.Split('|')[2];
// dcrStatusOld = ((dcrStatusOld == "Applied") ? "1" : "0");
string TwoActivityoldReason = twoActivityDCRApproval.Split('|')[3];
string TwoActivityleaveTypeName = twoActivityDCRApproval.Split('|')[4];
string TwoActivitydcrDate = twoActivityDCRApproval.Split('|')[5];
objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
dcrStatus = (string)objData.ExecuteScalar("exec SP_hdGetDCRStatus '" + _objCurrentInfo.GetCompanyCode() + "','" + TwoActivitydcrCode + "','" + TwoActivityflag + "'");
}
if (dcrStatus == "1" || dcrStatus == "2") // Applied and Approved
{
objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + TwoActivitydcrCode + "','" + TwoActivityflag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + TwoActivitydcrStatusOld + "','" + userCode + "'");
}
int firstexpenseRowCount = 0;
firstexpenseRowCount = _objDALApproval.DeleteDCRExpense(TwoActivityflag, TwoActivitydcrCode, fareDailyAllowance);
if (DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK.ToUpper().Trim() == "ENABLED")
{
IDCRLock objDCRLock = new BLDCRLock();
List <DCRActivityLockModel> lstDCRActivityLockModel = new List <DCRActivityLockModel>();
DCRActivityLockModel dcrActivityLockModel = new DCRActivityLockModel();
string comany_Code = _objCurrentInfo.GetCompanyCode();
dcrActivityLockModel.User_Code = userCode;
dcrActivityLockModel.DCR_Actual_Date = dcr_Actual_Date;
dcrActivityLockModel.Activity_Flag = TwoActivityflag;
dcrActivityLockModel.Locked_Date = DateTime.Now.ToShortDateString();
lstDCRActivityLockModel.Add(dcrActivityLockModel);
int result = objDCRLock.InsertActivityLock(comany_Code, lstDCRActivityLockModel);
}
int result_History = _objApproval.InsertDcrHistory(_objCurrentInfo.GetCompanyCode(), TwoActivitydcrCode, TwoActivityflag);
}
else
{
return("FAIL:You cannot change the status of Unapproved DCRs.");
}
}
}
objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
dcrStatus = (string)objData.ExecuteScalar("exec SP_hdGetDCRStatus '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "'");
}
if (dcrStatus == "1" || dcrStatus == "2") // Applied and Approved
{
//START: The Leave entry validation finctionality commented as per Customer Service Request.
//if (flag == "L")
// {
//leaveTypeName = leaveType;
//isCurBalanceNeed = false;
//for (int j = 0; j < privValues.Length; j++)
//{
// if (privValues[j].ToString().Trim().ToUpper() == leaveTypeName.ToUpper())
// {
// isCurBalanceNeed = true;
// break;
// }
//}
//dblLeaveBalance = 0.0;
//if (isCurBalanceNeed)
//{
// objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
// {
// object leaveBal = objData.ExecuteScalar("exec SP_hdGetLeaveBalance '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + userCode + "'");
// if (leaveBal.ToString() != "" && leaveBal != null)
// {
// if (!string.IsNullOrEmpty(leaveBal.ToString()))
// {
// dblLeaveBalance = float.Parse(leaveBal.ToString());
// }
// }
// }
// if (dblLeaveBalance > 0)
// {
// objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
// {
// objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'");
// }
// objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
// {
// objData.ExecuteNonQuery("exec SP_hdUpdateUserLeaveCurBalance '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + userCode + "','" + dcrStatus + "','" + status + "'");
// }
// }
// else if (status == "0")
// {
// objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
// {
// objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'");
// }
// objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
// {
// objData.ExecuteNonQuery("exec SP_hdUpdateUserLeaveCurBalance '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + userCode + "','" + dcrStatus + "','" + status + "'");
// }
// }
// else
// {
// return "FAIL:Due to insufficient leave balance, unable to approve leave for " + leaveTypeName + "";
// }
//}
//else
//{
// objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
// {
// objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'");
//}
//}
//}
//END: The Leave entry validation finctionality commented as per Customer Service Request.
objData.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
objData.ExecuteNonQuery("exec SP_hdUpdateDCRApproval '" + _objCurrentInfo.GetCompanyCode() + "','" + dcrCode + "','" + flag + "','" + status + "','" + _objCurrentInfo.GetUserName() + "','" + DateTime.Now.ToString() + "','" + remarks + "','" + calcFieldStatus + "','" + userCode + "'");
}
if (flag.ToUpper() != "L" && status == "0")
{
int secondexpenseRowCount = 0;
secondexpenseRowCount = _objDALApproval.DeleteDCRExpense(flag, dcrCode, fareDailyAllowance);
}
if (DCR_ENTRY_UNAPPROVED_ACTIVITY_LOCK.ToUpper().Trim() == "ENABLED")
{
IDCRLock objDCRLock = new BLDCRLock();
List <DCRActivityLockModel> lstDCRActivityLockModel = new List <DCRActivityLockModel>();
DCRActivityLockModel dcrActivityLockModel = new DCRActivityLockModel();
string comany_Code = _objCurrentInfo.GetCompanyCode();
dcrActivityLockModel.User_Code = userCode;
dcrActivityLockModel.DCR_Actual_Date = dcr_Actual_Date;
dcrActivityLockModel.Activity_Flag = flag;
dcrActivityLockModel.Locked_Date = DateTime.Now.ToShortDateString();
lstDCRActivityLockModel.Add(dcrActivityLockModel);
int result = objDCRLock.InsertActivityLock(comany_Code, lstDCRActivityLockModel);
if (result > 0)
{
return("SUCCESS:Status Changed Successfully. But Insert Activity Lock Fail.");
}
}
int result_History = _objApproval.InsertDcrHistory(_objCurrentInfo.GetCompanyCode(), dcrCode, flag);
}
else
{
return("FAIL:You cannot change the status of Unapproved DCRs.");
}
return("SUCCESS:Status Changed Successfully");
}
finally
{
objData.CloseConnection();
}
}
//save functionality//
public string save(FormCollection collection)
{
string Result = string.Empty;
string UserCode = string.Empty;
string SelectDate = string.Empty;
string Content = string.Empty;
string UserinwardCode = string.Empty;
string UserinwardDetail = string.Empty, maxCode = string.Empty;
UserCode = collection["UserCode"];
SelectDate = collection["SelectDate"];
DataControl.Data objAppData = new DataControl.Data();
string queryMax = objAppData.getSingleValue(Session["Comp_Code"].ToString(), "SELECT CONVERT(VARCHAR,MAX(CAST(SUBSTRING(User_Inward_Code,4,LEN(User_Inward_Code)) AS INT))) FROM tbl_SFA_Inward_Stock");
maxCode = getMaxCode(Convert.ToInt64(queryMax), "UIC");
string userMaxCode = objAppData.getSingleValue(Session["Comp_Code"].ToString(), "SELECT CONVERT(VARCHAR,MAX(CAST(SUBSTRING(User_Inward_Detail,4,LEN(User_Inward_Detail)) AS INT))) FROM tbl_SFA_Inward_Details");
UserinwardCode = maxCode;
string[] strArr = collection["Content"].Split('^');
string ProductCode = "";
string InwardStock = "";
string BatchNumber = "";
string strSQL = "";
string strSqlInward = "";
string userInwardCode = "";
string Remarks = "";
//string productDetails = "";
DataControl.Data ds = new DataControl.Data();
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
strSQL = "EXEC Sp_hdInwardStock_Insert " + "'" + _objCurrentInfo.GetCompanyCode() + "','" + UserCode + "','" + SelectDate + "'";
userInwardCode = ds.ExecuteScalar(strSQL).ToString();
ds.CloseConnection();
}
if (strArr.Length > 0)
{
for (int i = 0; i < strArr.Length; i++)
{
if (strArr[i] != string.Empty)
{
//userMaxCode = (Convert.ToInt64(userMaxCode) + 1).ToString();
//UserinwardDetail = objAppData.getMaxValues(userMaxCode, "UDC");
ProductCode = strArr[i].Split('_')[0];
BatchNumber = strArr[i].Split('_')[1].Trim();
InwardStock = strArr[i].Split('_')[2];
Remarks = strArr[i].Split('_')[4];
strSqlInward += "EXEC Sp_hdInwardDetails_Insert " + "'" + _objCurrentInfo.GetCompanyCode() + "','" + UserCode + "','" + userInwardCode + "','" + ProductCode + "','" + BatchNumber + "','" + InwardStock + "','" + Remarks + "';";
}
}
}
ds.OpenConnection(_objCurrentInfo.GetCompanyCode());
{
ds.ExecuteNonQuery(strSqlInward);
ds.CloseConnection();
}
return("INSERTED");
}
public int InsertDivisionEntityMapping(List <MVCModels.DivisionModel> lstDivision, string entityCode, string entityName, string companyCode, string userCode, string regionCode, string divisionCode)
{
int rowsAffected = 0;
if (entityName == "PRODUCT")
{
IDbConnection connection = connection = IDbOpenConnection();
IDbTransaction trans = connection.BeginTransaction();
try
{
// HAVE TO CHECK THIS
int count = 0;
string selectQry = "SELECT COUNT(1) FROM tbl_SFA_Division_Entity_Mapping WHERE Company_Code=@Company_Code AND Division_Code=@Division_Code " +
"AND Entity_Type=@Entity_Type";
count = connection.Query <int>(selectQry, new { Company_Code = companyCode, Division_Code = divisionCode, Entity_Type = entityName },
transaction: trans).Single();
if (count > 0)
{
string deleteQry = "DELETE FROM tbl_SFA_Division_Entity_Mapping WHERE Company_Code=@Company_Code AND Division_Code=@Division_Code " +
"AND Entity_Type=@Entity_Type";
rowsAffected = connection.Execute(deleteQry, new { Company_Code = companyCode, Division_Code = divisionCode, Entity_Type = entityName },
transaction: trans);
if (rowsAffected > 0)
{
rowsAffected = 0;
string insertQry = "insert into tbl_SFA_Division_Entity_Mapping(Company_Code,Division_Code, Entity_Code,Entity_Type,Record_Status, " +
"Created_By,Created_Date,Updated_By,Updated_Date) " +
"values(@Company_Code, @Division_Code,@Entity_Code,@Entity_Type,@Record_Status,@Created_By,@Created_Date,@Updated_By,@Updated_Date)";
rowsAffected = connection.Execute(insertQry, lstDivision, transaction: trans);
}
}
else
{
string insertQry = "insert into tbl_SFA_Division_Entity_Mapping(Company_Code,Division_Code, Entity_Code,Entity_Type,Record_Status, " +
"Created_By,Created_Date,Updated_By,Updated_Date) " +
"values(@Company_Code, @Division_Code,@Entity_Code,@Entity_Type,@Record_Status,@Created_By,@Created_Date,@Updated_By,@Updated_Date)";
rowsAffected = connection.Execute(insertQry, lstDivision, transaction: trans);
}
trans.Commit();
}
catch (Exception ex)
{
trans.Rollback();
Dictionary <string, string> dicObj = new Dictionary <string, string>();
dicObj.Add("divisionCode", divisionCode);
dicObj.Add("entity", entityName);
Impl.ExceptionHandler.WriteLog(ex: ex, dic: dicObj);
return(0);
}
finally
{
connection.Close();
}
}
else
{
_objSPData = new SPData();
_objData = new Data();
try
{
string cmdText = "SP_hdGetChildEntityCodeIncluesSelf";
SqlCommand command = new SqlCommand(cmdText);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
if (entityName == "REGION")
{
_objSPData.AddParamToSqlCommand(command, "@EntityCode", ParameterDirection.Input, SqlDbType.VarChar, 30, regionCode);
}
else
{
_objSPData.AddParamToSqlCommand(command, "@EntityCode", ParameterDirection.Input, SqlDbType.VarChar, 30, userCode);
}
_objSPData.AddParamToSqlCommand(command, "@EntityType", ParameterDirection.Input, SqlDbType.VarChar, 30, entityName);
_objSPData.AddParamToSqlCommand(command, "@DivisionCode", ParameterDirection.Input, SqlDbType.VarChar, 30, divisionCode);
if (lstDivision.Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@Division_Entity_Mapping_TVP", ParameterDirection.Input, SqlDbType.Structured, null, "Division_Entity_Mapping_TVP");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@Division_Entity_Mapping_TVP", ParameterDirection.Input, SqlDbType.Structured, new DivisionMappingEnumurator(lstDivision.AsEnumerable()), "Division_Entity_Mapping_TVP");
}
_objSPData.AddParamToSqlCommand(command, "@Result", ParameterDirection.Output, SqlDbType.VarChar, 30, "");
_objData.OpenConnection(companyCode);
_objData.ExecuteNonQuery(command);
rowsAffected = Convert.ToInt32(command.Parameters["@Result"].Value);
}
catch
{
throw;
}
}
return(rowsAffected);
}
