public async Task <JsonResult> Verify(MonthlyExpenseVerifyViewModel MonthlyExpenseVerify)
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
DateTime monthYear = DateTime.ParseExact(MonthlyExpenseVerify.MonthYear, "MM/yyyy", enUS);
StringBuilder SQLStringBuilder = new StringBuilder();
string[] branchLists = MonthlyExpenseVerify.BranchID.Split(',');
foreach (var branch in branchLists)
{
if (MonthlyExpenseVerify.Type.Equals("acc"))
{
SQLStringBuilder.AppendLine($"EXEC sp_RPT310_SaveMonthlyExpenseAccountVerify '{UserData.Username}', '{branch}', {monthYear.Month.ToString()}, {monthYear.Year.ToString()}");
}
else if (MonthlyExpenseVerify.Type.Equals("ops"))
{
SQLStringBuilder.AppendLine($"EXEC sp_RPT310_SaveMonthlyExpenseOpsAdminVerify '{UserData.Username}', '{branch}', {monthYear.Month.ToString()}, {monthYear.Year.ToString()}");
}
else if (MonthlyExpenseVerify.Type.Equals("rt"))
{
SQLStringBuilder.AppendLine($"EXEC sp_RPT310_SaveMonthlyExpenseRetailVerify '{UserData.Username}', '{branch}', {monthYear.Month.ToString()}, {monthYear.Year.ToString()}");
}
else if (MonthlyExpenseVerify.Type.Equals("rtsupply"))
{
SQLStringBuilder.AppendLine($"EXEC sp_RPT310_SaveMonthlyExpenseRetailSupplyVerify '{UserData.Username}', '{branch}', {monthYear.Month.ToString()}, {monthYear.Year.ToString()}");
}
}
string strSQL = SQLStringBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <JsonResult> Post(DHLVerifyRTUpdateViewModel Item)
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
DateTime monthYear = DateTime.ParseExact(Item.MonthYear, "MM/yyyy", enUS);
decimal dhlAdjustment = 0;
if (decimal.TryParse(Item.DHLAdjustment, out dhlAdjustment))
{
}
StringBuilder sqlStrBuilder = new StringBuilder();
sqlStrBuilder.Append("EXEC sp_RPT313_DHLVerifyUpdate '");
sqlStrBuilder.Append(UserData.Username);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.BranchID);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(monthYear.Month.ToString());
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(monthYear.Year.ToString());
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(dhlAdjustment);
sqlStrBuilder.Append("'");
string strSQL = sqlStrBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <JsonResult> Post()
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
string idList = HttpContext.Request.Form["IDs"].ToString().ToUpper();
string[] idLists = idList.Split(',');
StringBuilder sqlStrBuilder = new StringBuilder();
foreach (var x in idLists)
{
string[] xSplit = x.Split('-');
sqlStrBuilder.Append("EXEC sp_PDC_Report_DailyRevenueConfirm_Set '");
sqlStrBuilder.Append(xSplit[1]);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(UserData.Username);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(xSplit[0]);
sqlStrBuilder.AppendLine("'");
}
string strSQL = sqlStrBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <JsonResult> Post(UpdatePRViewModel UpdatePR)
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
DateTime monthYear = DateTime.ParseExact(UpdatePR.MonthYear, "MM/yyyy", enUS);
StringBuilder SQLStringBuilder = new StringBuilder();
for (int i = 0; i < UpdatePR.BranchID.Count(); i++)
{
SQLStringBuilder.AppendLine($"EXEC sp_RPT312_UpdatePR '{UserData.Username}', '{UpdatePR.BranchID[i]}', '{UpdatePR.PR[i]}', '{monthYear.Month.ToString()}', '{monthYear.Year.ToString()}'");
}
string strSQL = SQLStringBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <JsonResult> PostVerifySelection(DCTopUpVerifySelectionViewModel Item)
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
DateTime verifyDate = DateTime.ParseExact(Item.VerifyDate, "dd/MM/yyyy", enUS);
DateTime remittanceDate = DateTime.ParseExact(Item.RemittanceDate, "dd/MM/yyyy", enUS);
string idList = Item.IDList.ToUpper();
string[] idLists = idList.Split(',');
StringBuilder sqlStrBuilder = new StringBuilder();
foreach (var x in idLists)
{
string[] xSplit = x.Split('-');
sqlStrBuilder.Append("EXEC sp_PDC_Report_DCTopUpVerify_Set '");
sqlStrBuilder.Append(UserData.Username);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(xSplit[1]);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(xSplit[0]);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(verifyDate.ToString("yyyyMMdd", enUS));
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(remittanceDate.ToString("yyyyMMdd", enUS));
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@BonusCommission
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@AdjCreditCard
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@AdjustmentOther
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@ReturnCharge
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@Suspense
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@WithHoldingTax
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@Promotion
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@BankCharge
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append("0"); //@AdjLinePay
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@BonusCommissionRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@AdjCreditCardRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@AdjustmentOtherRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@ReturnChargeRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@SuspenseRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@WithHoldingTaxRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@PromotionRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@BankChargeRemark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(""); //@AdjLinePayRemark
sqlStrBuilder.Append("'");
sqlStrBuilder.AppendLine();
}
string strSQL = sqlStrBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <JsonResult> Post(string BranchID, DCTopUpVerifyViewModel Item)
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
string idList = HttpContext.Request.Form["IDs"].ToString().ToUpper();
string[] idLists = idList.Split(',');
StringBuilder sqlStrBuilder = new StringBuilder();
sqlStrBuilder.Append("EXEC sp_PDC_Report_DCTopUpVerify_Set '");
sqlStrBuilder.Append(UserData.Username);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(BranchID);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.ReportDate);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.VerifyDate);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.RemittanceDate);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.BonusCommission);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.AdjustmentCreditCard);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.AdjustmentOther);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.ReturnCharge);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.Suspense);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.WithHoldingTax);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.Promotion);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.BankCharge);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(Item.AdjustmentLinePay);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.BonusCommissionRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.AdjustmentCreditCardRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.AdjustmentOtherRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.ReturnChargeRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.SuspenseRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.WithHoldingTaxRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.PromotionRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.BankChargeRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(Item.AdjustmentCreditCardRemark);
sqlStrBuilder.Append("'");
string strSQL = sqlStrBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <JsonResult> Post(MonthlyExpenseUpdateViewModel MonthlyExpenseUpdate)
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
IEnumerable <IGrouping <string, IFormFile> > File = Request.Form.Files.GroupBy(f => f.Name);
DateTime monthYear = DateTime.ParseExact(MonthlyExpenseUpdate.MonthYear, "MM/yyyy", enUS);
string userID = UserData.Username;
string branchID = MonthlyExpenseUpdate.BranchID;
string month = monthYear.Month.ToString();
string year = monthYear.Year.ToString();
StringBuilder SQLStringBuilder = new StringBuilder();
#region Management Fee
if (!string.IsNullOrEmpty(MonthlyExpenseUpdate.ManagementFee))
{
decimal managementFee = 0;
if (decimal.TryParse(MonthlyExpenseUpdate.ManagementFee, out managementFee))
{
}
SQLStringBuilder.AppendLine(GenSQLString(
userID // @u_id
, branchID // @branch_id
, month // @month
, year // @year
, "MANAGEMENT_FEE" // @item_desc
, MonthlyExpenseUpdate.ManagementFeeID[0] // @item_id
, 1 // @category_id
, 1 // @item_amount
, managementFee // @item_expense
, null // @remark
, null // @attachment
, "false"
));
}
#endregion
#region Service Fee - IT
if (MonthlyExpenseUpdate.ServiceFeeITExpense != null)
{
for (int i = 0; i < MonthlyExpenseUpdate.ServiceFeeITExpense.Count(); i++)
{
if (MonthlyExpenseUpdate.ServiceFeeITItem[i] == null && MonthlyExpenseUpdate.ServiceFeeITID[i] == null)
{
continue;
}
string item_desc = MonthlyExpenseUpdate.ServiceFeeITItem[i];
string itemID = string.IsNullOrEmpty(MonthlyExpenseUpdate.ServiceFeeITID[i]) ? null : MonthlyExpenseUpdate.ServiceFeeITID[i];
int category_id = 2;
int amount = 1;
decimal expense = 0;
string remark = string.IsNullOrEmpty(MonthlyExpenseUpdate.ServiceFeeITRemark[i]) ? null : MonthlyExpenseUpdate.ServiceFeeITRemark[i];
string attach = null;
string trash = MonthlyExpenseUpdate.ServiceFeeITTrash[i].ToString().ToLower();
IGrouping <string, IFormFile> file = File.SingleOrDefault(f => f.Key.Equals("ServiceFeeITAttach"));
if (file != null)
{
IFormFile attachFile = File.SingleOrDefault(f => f.Key.Equals("ServiceFeeITAttach")).ToArray()[i];
if (attachFile.Length > 0)
{
attach = UploadFile(attachFile, year, month, branchID, category_id);
}
}
if (decimal.TryParse(MonthlyExpenseUpdate.ServiceFeeITExpense[i], out expense))
{
}
SQLStringBuilder.AppendLine(GenSQLString(
userID, branchID, month, year, item_desc, itemID, category_id, amount, expense, remark, attach, trash
));
}
}
#endregion
#region Service Fee - Supply
if (MonthlyExpenseUpdate.ServiceFeeSupplyExpense != null)
{
for (int i = 0; i < MonthlyExpenseUpdate.ServiceFeeSupplyExpense.Count(); i++)
{
if (MonthlyExpenseUpdate.ServiceFeeSupplyItem[i] == null && MonthlyExpenseUpdate.ServiceFeeSupplyID[i] == null)
{
continue;
}
string item_desc = MonthlyExpenseUpdate.ServiceFeeSupplyItem[i];
string itemID = string.IsNullOrEmpty(MonthlyExpenseUpdate.ServiceFeeSupplyID[i]) ? null : MonthlyExpenseUpdate.ServiceFeeSupplyID[i];
int category_id = 3;
int amount = 1;
decimal expense;
string remark = string.IsNullOrEmpty(MonthlyExpenseUpdate.ServiceFeeSupplyRemark[i]) ? null : MonthlyExpenseUpdate.ServiceFeeSupplyRemark[i];
string attach = null;
string trash = MonthlyExpenseUpdate.ServiceFeeSupplyTrash[i].ToString().ToLower();
IGrouping <string, IFormFile> file = File.SingleOrDefault(f => f.Key.Equals("ServiceFeeSupplyAttach"));
if (file != null)
{
IFormFile attachFile = File.SingleOrDefault(f => f.Key.Equals("ServiceFeeSupplyAttach")).ToArray()[i];
if (attachFile.Length > 0)
{
attach = UploadFile(attachFile, year, month, branchID, category_id);
}
}
if (decimal.TryParse(MonthlyExpenseUpdate.ServiceFeeSupplyExpense[i], out expense))
{
}
SQLStringBuilder.AppendLine(GenSQLString(
userID, branchID, month, year, item_desc, itemID, category_id, amount, expense, remark, attach, trash
));
}
}
#endregion
#region Service Fee - Facility
if (MonthlyExpenseUpdate.ServiceFeeFacilityExpense != null)
{
for (int i = 0; i < MonthlyExpenseUpdate.ServiceFeeFacilityExpense.Count(); i++)
{
if (MonthlyExpenseUpdate.ServiceFeeFacilityItem[i] == null && MonthlyExpenseUpdate.ServiceFeeFacilityID[i] == null)
{
continue;
}
string item_desc = MonthlyExpenseUpdate.ServiceFeeFacilityItem[i];
string itemID = string.IsNullOrEmpty(MonthlyExpenseUpdate.ServiceFeeFacilityID[i]) ? null : MonthlyExpenseUpdate.ServiceFeeFacilityID[i];
int category_id = 4;
int amount = 1;
decimal expense = 0;
string remark = string.IsNullOrEmpty(MonthlyExpenseUpdate.ServiceFeeFacilityRemark[i]) ? null : MonthlyExpenseUpdate.ServiceFeeFacilityRemark[i];
string attach = null;
string trash = "false"; // MonthlyExpenseUpdate.ServiceFeeFacilityTrash[i].ToString().ToLower();
IGrouping <string, IFormFile> file = File.SingleOrDefault(f => f.Key.Equals("ServiceFeeFacilityAttach"));
if (file != null)
{
IFormFile attachFile = File.SingleOrDefault(f => f.Key.Equals("ServiceFeeFacilityAttach")).ToArray()[i];
if (attachFile.Length > 0)
{
attach = UploadFile(attachFile, year, month, branchID, category_id);
}
}
if (decimal.TryParse(MonthlyExpenseUpdate.ServiceFeeFacilityExpense[i], out expense))
{
}
SQLStringBuilder.AppendLine(GenSQLString(
userID, branchID, month, year, item_desc, itemID, category_id, amount, expense, remark, attach, trash
));
}
}
#endregion
#region Sales Package
if (MonthlyExpenseUpdate.SalesPackageAmount != null)
{
for (int i = 0; i < MonthlyExpenseUpdate.SalesPackageAmount.Count(); i++)
{
if (string.IsNullOrEmpty(MonthlyExpenseUpdate.SalesPackageAmount[i]) && MonthlyExpenseUpdate.SalesPackageID[i] == null)
{
continue;
}
string item_desc = MonthlyExpenseUpdate.SalesPackageItem[i];
string itemID = string.IsNullOrEmpty(MonthlyExpenseUpdate.SalesPackageID[i]) ? null : MonthlyExpenseUpdate.SalesPackageID[i];
int category_id = 5;
int amount = 0;
decimal expense;
string remark = string.IsNullOrEmpty(MonthlyExpenseUpdate.SalesPackageRemark[i]) ? null : MonthlyExpenseUpdate.SalesPackageRemark[i];
string attach = null;
string trash = "false"; // MonthlyExpenseUpdate.SalesPackageTrash[i].ToString().ToLower();
IGrouping <string, IFormFile> file = File.SingleOrDefault(f => f.Key.Equals("SalesPackageAttach"));
if (file != null)
{
IFormFile attachFile = File.SingleOrDefault(f => f.Key.Equals("SalesPackageAttach")).ToArray()[i];
if (attachFile.Length > 0)
{
attach = UploadFile(attachFile, year, month, branchID, category_id);
}
}
if (int.TryParse(MonthlyExpenseUpdate.SalesPackageAmount[i], out amount))
{
}
if (decimal.TryParse(MonthlyExpenseUpdate.SalesPackageExpense[i], out expense))
{
}
SQLStringBuilder.AppendLine(GenSQLString(
userID, branchID, month, year, item_desc, itemID, category_id, amount, expense, remark, attach, trash
));
}
}
#endregion
#region Adjustment
if (!string.IsNullOrEmpty(MonthlyExpenseUpdate.Adjustment))
{
decimal adjustment = 0;
if (decimal.TryParse(MonthlyExpenseUpdate.Adjustment, out adjustment))
{
}
SQLStringBuilder.AppendLine(GenSQLString(
userID // @u_id
, branchID // @branch_id
, month // @month
, year // @year
, "ADJUSTMENT" // @item_desc
, MonthlyExpenseUpdate.AdjustmentID[0] // @item_id
, 6 // @category_id
, 1 // @item_amount
, adjustment // @item_expense
, string.IsNullOrEmpty(MonthlyExpenseUpdate.AdjustmentRemark[0]) ? null : MonthlyExpenseUpdate.AdjustmentRemark[0] // @remark
, null // @attachment
, "false"
));
}
#endregion
string strSQL = SQLStringBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <JsonResult> Post(DailyRevenueDetailViewModel adjustment)
{
if (!ModelState.IsValid)
{
return(Json(Response.RenderError(ModelState)));
}
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
DateTime verifydate = DateTime.ParseExact(adjustment.VerifyDate, "dd/MM/yyyy", new CultureInfo("en-US"));
DateTime remittanceDate = DateTime.ParseExact(adjustment.RemittanceDate, "dd/MM/yyyy", new CultureInfo("en-US"));
StringBuilder sqlStrBuilder = new StringBuilder();
sqlStrBuilder.Append("EXEC sp_PDC_Report_DailyRevenueVerify_Set '");
sqlStrBuilder.Append(adjustment.ReportDate.ToString("yyyyMMdd", new CultureInfo("en-US")));
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(UserData.Username);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.Branch);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.Comm);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.AdjCreditCard);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.Other);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.Return);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.Suspensse);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.WithHoldingTax);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.Promotion);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.BankCharge);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.AdjLinePay);
//add by kathawutpa 17/7/2019 for project sales x
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(adjustment.Project);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(verifydate.ToString("yyyyMMdd", new CultureInfo("en-US")));
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(remittanceDate.ToString("yyyyMMdd", new CultureInfo("en-US")));
//Remark
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.CommRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.AdjCreditCardRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.OtherRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.ReturnRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.SuspensseRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.WithHoldingTaxRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.PromotionRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.BankChargeRemark);
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.AdjLinePayRemark);
//add by kathawutpa 17/7/2019 for project sales x
sqlStrBuilder.Append("', N'");
sqlStrBuilder.Append(adjustment.ProjectRemark);
sqlStrBuilder.Append("'");
string strSQL = sqlStrBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
Response.Result = adjustment;
DB.Dispose();
return(Json(Response.Render()));
}
public async Task <ActionResult> Post()
{
// Auth Data
var userData = User.Claims.SingleOrDefault(c => c.Type.Equals("User")).Value;
UserMapRole UserData = JsonConvert.DeserializeObject <UserMapRole>(userData);
string idList = HttpContext.Request.Form["IDs"].ToString().ToUpper();
if (string.IsNullOrEmpty(idList))
{
Response.Success = false;
Response.Errors.Add(new
{
Code = 404,
Message = "Not Found"
});
HttpContext.Response.StatusCode = (int)HttpStatusCode.NotFound;
return(Json(Response.Render()));
}
string[] idLists = idList.Split(',');
StringBuilder sqlStrBuilder = new StringBuilder();
foreach (var x in idLists)
{
string[] xSplit = x.Split('-');
sqlStrBuilder.Append("EXEC sp_RPT301_SaveDailyRevenueConfirmFC '");
sqlStrBuilder.Append(xSplit[1]);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(UserData.Username);
sqlStrBuilder.Append("', '");
sqlStrBuilder.Append(xSplit[0]);
sqlStrBuilder.Append("'");
sqlStrBuilder.AppendLine();
}
string strSQL = sqlStrBuilder.ToString();
#region Product
if (_hostingEnvironment.IsProduction())
{
SaveDBResponse save = await DB.SaveDBResponse.FromSql(strSQL).FirstAsync();
Response.Success = save.code.Equals("000");
Response.Messages.Add(save.desc);
}
#endregion
#region Tester
else
{
Response.Success = true;
Response.Messages.Add("Test");
}
#endregion
//Response.Result = adjustment;
DB.Dispose();
return(Json(Response.Render()));
}
