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