public Task <string> Save(PharSalesModel aModel)
{
try
{
Con.Open();
Thread.Sleep(5);
_trans = Con.BeginTransaction();
string trNo = GetTrNo("TrNo", "tbl_PHAR_PURCHASE_LEDGER", _trans);
string invoiceNo = trNo;
const string query = @"INSERT INTO tbl_PHAR_COMPANY (Name,Address,Phone,EntryDate,UserName)
output inserted.id VALUES (@Name,@Address,@Phone,@EntryDate,@UserName)" ;
var cmd = new SqlCommand(query, Con, _trans);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Name", aModel.Name);
cmd.Parameters.AddWithValue("@Address", aModel.Address);
cmd.Parameters.AddWithValue("@Phone", aModel.Phone);
cmd.Parameters.AddWithValue("@EntryDate", DateTime.Now.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@UserName", aModel.UserName);
cmd.Parameters.AddWithValue("@Status", aModel.Status);
var comid = (int)cmd.ExecuteScalar();
// tbl_PHAR_PURCHASE_LEDGER
const string query2 = @"INSERT INTO tbl_PHAR_PURCHASE_LEDGER (TrNo,TrDate,InvoiceNo,InvoiceDate,ComPanyId,PurchaseAmount,LessAmount,PaymentAmount,Status,SubSubPnoId,UserName,PaymentStatus,BranchId,EntryDate,EntryTime) VALUES (@TrNo,@TrDate,@InvoiceNo,@InvoiceDate,@ComPanyId,@PurchaseAmount,@LessAmount,@PaymentAmount,@Status,@SubSubPnoId,@UserName,@PaymentStatus,@BranchId,@EntryDate,@EntryTime)";
var cmd2 = new SqlCommand(query2, Con, _trans);
cmd2.Parameters.Clear();
cmd2.Parameters.AddWithValue("@TrNo", trNo);
cmd2.Parameters.AddWithValue("@TrDate", aModel.InvoiceDate.ToString("yyyy-MM-dd"));
cmd2.Parameters.AddWithValue("@InvoiceNo", invoiceNo);
cmd2.Parameters.AddWithValue("@InvoiceDate", aModel.InvoiceDate.ToString("yyyy-MM-dd"));
cmd2.Parameters.AddWithValue("@ComPanyId", comid);
cmd2.Parameters.AddWithValue("@PurchaseAmount", aModel.TotalPrice);
cmd2.Parameters.AddWithValue("@LessAmount", 0);
cmd2.Parameters.AddWithValue("@PaymentAmount", 0);
cmd2.Parameters.AddWithValue("@Status", "Opening Balance");
cmd2.Parameters.AddWithValue("@SubSubPnoId", "65");
cmd2.Parameters.AddWithValue("@UserName", aModel.UserName);
cmd2.Parameters.AddWithValue("@BranchId", GetBranchIdByuserNameOpenCon(aModel.UserName, _trans));
cmd2.Parameters.AddWithValue("@EntryTime", DateTime.Now.ToShortTimeString());
cmd2.Parameters.AddWithValue("@PaymentStatus", aModel.PaymentAmt > 0 ? 2 : 1);
cmd2.Parameters.AddWithValue("@EntryDate", DateTime.Now.ToString("yyyy-MM-dd"));
cmd2.ExecuteNonQuery();
_trans.Commit();
Con.Close();
return(Task.FromResult("Save successful"));
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
Con.Close();
}
return(Task.FromResult(exception.Message));
}
}
public async Task <HttpResponseMessage> Save_COMPANY_PHAR([FromBody] PharSalesModel aModel)
{
var formate = RequestFormat.JsonFormaterString();
try
{
if (string.IsNullOrEmpty(aModel.Name))
{
return(Request.CreateResponse(HttpStatusCode.OK,
new Confirmation {
Output = "error", Msg = "Name is Empty"
}, formate));
}
//if (aModel.PdGroupId == 0)
//{
// return Request.CreateResponse(HttpStatusCode.OK,
// new Confirmation { Output = "error", Msg = "PdGroupe Id Cannot be Zero" }, formate);
//}
else
{
if (_gt.FncSeekRecordNew("tbl_PHAR_COMPANY", "Id=" + aModel.Id + "") == false)
{
string msg = await _gt.Save(aModel);
return(Request.CreateResponse(HttpStatusCode.OK,
new Confirmation {
Output = "success", Msg = msg
}, formate));
}
else
{
string msg = await _gt.Update(aModel);
return(Request.CreateResponse(HttpStatusCode.OK,
new Confirmation {
Output = "success", Msg = msg
}, formate));
}
}
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK
, new Confirmation {
Output = "error", Msg = ex.ToString()
}, formate));
}
}
public async Task <HttpResponseMessage> Save([FromBody] PharSalesModel aModel)
{
var formate = RequestFormat.JsonFormaterString();
try
{
string msg = await _pharPurchasePayment.Save(aModel);
return(Request.CreateResponse(HttpStatusCode.OK,
new Confirmation {
Output = "success", Msg = msg
}, formate));
}
catch (Exception ex)
{
return(Request.CreateResponse(HttpStatusCode.OK
, new Confirmation {
Output = "error", Msg = ex.ToString()
}, formate));
}
}
public Task <string> Save(PharSalesModel aModel)
{
try
{
Con.Open();
Thread.Sleep(5);
_trans = Con.BeginTransaction();
string trNo = GetTrNo("TrNo", "tbl_PHAR_PURCHASE_LEDGER", _trans);
string trNoDuePayment = GetAutoIncrementNumberFromStoreProcedure(10, _trans);
const string query2 = @"INSERT INTO tbl_PHAR_PURCHASE_LEDGER (TrNo,TrDate,InvoiceNo,InvoiceDate,ComPanyId,PurchaseAmount,LessAmount,PaymentAmount,Status,SubSubPnoId,UserName,PaymentStatus,BranchId,EntryDate,EntryTime) VALUES (@TrNo,@TrDate,@InvoiceNo,@InvoiceDate,@ComPanyId,@PurchaseAmount,@LessAmount,@PaymentAmount,@Status,@SubSubPnoId,@UserName,@PaymentStatus,@BranchId,@EntryDate,@EntryTime)";
var cmd = new SqlCommand(query2, Con, _trans);
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@TrNo", trNo);
cmd.Parameters.AddWithValue("@TrDate", DateTime.Now.ToString("yyyy-MM-dd"));
cmd.Parameters.AddWithValue("@InvoiceNo", aModel.InvoiceNo);
cmd.Parameters.AddWithValue("@InvoiceDate", aModel.InvoiceDate);
cmd.Parameters.AddWithValue("@ComPanyId", aModel.CompanyId);
cmd.Parameters.AddWithValue("@PurchaseAmount", 0);
cmd.Parameters.AddWithValue("@LessAmount", aModel.LessAmt);
cmd.Parameters.AddWithValue("@PaymentAmount", aModel.PaymentAmt);
cmd.Parameters.AddWithValue("@Status", "Due Payment");
cmd.Parameters.AddWithValue("@SubSubPnoId", "65");
cmd.Parameters.AddWithValue("@UserName", aModel.UserName);
cmd.Parameters.AddWithValue("@BranchId", GetBranchIdByuserNameOpenCon(aModel.UserName, _trans));
cmd.Parameters.AddWithValue("@EntryTime", DateTime.Now.ToShortTimeString());
cmd.Parameters.AddWithValue("@PaymentStatus", aModel.PaymentAmt > 0 ? 3 : 1); //
cmd.Parameters.AddWithValue("@EntryDate", DateTime.Now.ToString("yyyy-MM-dd"));
cmd.ExecuteNonQuery();
const string query3 = @"INSERT INTO tbl_PHAR_DUE_PAYMENT (TrNo,TrDate,InvoiceNo,Invoicedate,CompanyId,PaymentAmount,LessAmount,LessPc,LessPcOrTk,SubSubPnoId,CashAmount,CardAmount) VALUES (@TrNo,@TrDate,@InvoiceNo,@Invoicedate,@CompanyId,@PaymentAmount,@LessAmount,@LessPc,@LessPcOrTk,@SubSubPnoId,@CashAmount,@CardAmount)";
var cmd2 = new SqlCommand(query3, Con, _trans);
cmd2.Parameters.Clear();
cmd2.Parameters.AddWithValue("@TrNo", trNoDuePayment);
cmd2.Parameters.AddWithValue("@TrDate", DateTime.Now.ToString("yyyy-MM-dd"));
cmd2.Parameters.AddWithValue("@InvoiceNo", aModel.InvoiceNo);
cmd2.Parameters.AddWithValue("@Invoicedate", aModel.InvoiceDate);
cmd2.Parameters.AddWithValue("@CompanyId", aModel.CompanyId);
cmd2.Parameters.AddWithValue("@PaymentAmount", aModel.PaymentAmt);
cmd2.Parameters.AddWithValue("@LessAmount", aModel.LessAmt);
cmd2.Parameters.AddWithValue("@LessPc", aModel.LessPc);
cmd2.Parameters.AddWithValue("@LessPcOrTk", aModel.LessPcOrTk);
cmd2.Parameters.AddWithValue("@SubSubPnoId", "65");
cmd2.Parameters.AddWithValue("@CashAmount", aModel.CashAmt);
cmd2.Parameters.AddWithValue("@CardAmount", aModel.CardAmt);
_trans.Commit();
Con.Close();
return(Task.FromResult("Save successful"));
}
catch (Exception exception)
{
if (Con.State == ConnectionState.Open)
{
_trans.Rollback();
Con.Close();
}
return(Task.FromResult(exception.Message));
}
}
