// FOR BACK PAY public void Create_BP_Log_Details_employer(Remit_Con_Log_Details remitconlogDetails) { try { var param = new DynamicParameters(); ///create log for the upload Remit Log param.Add(name: "p_Employee_Id", value: remitconlogDetails.Employee_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_ESF_ID", value: remitconlogDetails.Esf_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Con_Log_Id", value: remitconlogDetails.Con_Log_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Employer_Con", value: remitconlogDetails.Employer_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Con", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employer_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employer_Amt_Used", value: remitconlogDetails.Employer_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Amt_Used", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Maker_Id", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Auth_Status", value: "AUTHORIZED", dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Salary", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Sal_Rate", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Req_Con", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Difference", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Req_Status", value: "ACTIVE", dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Con_Type", value: "BACK-PAY", dbType: DbType.String, direction: ParameterDirection.Input); db.GetConnection().Execute(sql: "ADD_MIGRATE_CON_DETAILS", param: param, commandType: CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } }
public void Create_Con_Log_Details_BP(Remit_Con_Log_Details remitconlogDetails) { try { //////////////////////////////////////////////// if (remitconlogDetails.For_Month.ToString().Length == 1) { clog = "0" + remitconlogDetails.For_Month; } else { clog = remitconlogDetails.For_Month.ToString(); } /////////////////////////////////////////////////// var param = new DynamicParameters(); ///create log for the upload Remit Log param.Add(name: "p_Employee_Id", value: remitconlogDetails.Employee_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_ESF_ID", value: remitconlogDetails.Esf_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Con_Log_Id", value: remitconlogDetails.Con_Log_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Employer_Con", value: remitconlogDetails.Employer_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Con", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employer_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Bal", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employer_Amt_Used", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Amt_Used", value: remitconlogDetails.Employee_Con, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Maker_Id", value: GlobalValue.User_ID, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Make_date", value: GlobalValue.Scheme_Today_Date, dbType: DbType.DateTime, direction: ParameterDirection.Input); param.Add(name: "p_Auth_Status", value: "AUTHORIZED", dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Salary", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Sal_Rate", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Req_Con", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Difference", value: 0, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Req_Status", value: "ACTIVE", dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Con_Type", value: "BACKPAY-CONTRIBUTION", dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Trustee_Name", value: "", dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_BatchNo", value: remitconlogDetails.ES_Id + "01", dbType: DbType.String, direction: ParameterDirection.Input); db.GetConnection().Execute(sql: "ADD_REMIT_CON_DETAILS_TRANS", param: param, commandType: CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } }
public void Create_Unit_Log_Details_Employer(Remit_Con_Log_Details remitconlogDetails) { try { var param = new DynamicParameters(); ///create log for the upload Remit Log param.Add(name: "p_ESF_ID", value: remitconlogDetails.Esf_Id, dbType: DbType.String, direction: ParameterDirection.Input); param.Add(name: "p_Employer_Amt", value: remitconlogDetails.Employer_Amt, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Employee_Amt", value: remitconlogDetails.Employee_Amt, dbType: DbType.Decimal, direction: ParameterDirection.Input); param.Add(name: "p_Purchase_Log_Id", value: remitconlogDetails.Purchase_Log_Id, dbType: DbType.String, direction: ParameterDirection.Input); db.GetConnection().Execute(sql: "ADD_MIGRATE_CON_EMPLOYER", param: param, commandType: CommandType.StoredProcedure); } catch (Exception ex) { throw ex; } finally { db.Dispose(); } }