public MVCQutationModel GetQutationById(int QutationId)
{
HttpResponseMessage responseQutation = GlobalVeriables.WebApiClient.GetAsync("APIQutation/" + QutationId.ToString()).Result;
MVCQutationModel QutationModel = responseQutation.Content.ReadAsAsync <MVCQutationModel>().Result;
return(QutationModel);
}
public IHttpActionResult GetQutationTable(int id)
{
MVCQutationModel qutationmodel = new MVCQutationModel();
qutationmodel = db.QutationTables.Where(q => q.QutationID == id).Select(c => new MVCQutationModel
{
QutationID = c.QutationID,
Qutation_ID = c.Qutation_ID,
RefNumber = c.RefNumber,
QutationDate = c.QutationDate,
DueDate = c.DueDate,
SubTotal = c.SubTotal,
TotalVat6 = c.TotalVat6,
TotalVat21 = c.TotalVat21,
DiscountAmount = c.DiscountAmount,
TotalAmount = c.TotalAmount,
CustomerNote = c.CustomerNote,
Status = c.Status,
UserId = c.UserId,
CompanyId = c.CompanyId,
ContactId = c.ContactId,
Type = c.Type,
}).FirstOrDefault();
if (qutationmodel == null)
{
return(NotFound());
}
return(Ok(qutationmodel));
}
public JsonResult UpdateOrderStaus(int QutationId, string Status, string Type)
{
List <MVCQutationViewModel> _QuatationModel = new List <MVCQutationViewModel>();
QutationOrderStatusTable orderstatusModel = new QutationOrderStatusTable();
List <MVCQutationViewModel> _QutationList = new List <MVCQutationViewModel>();
MVCQutationViewModel _mvcQuatationViewModel23 = new MVCQutationViewModel();
try
{
HttpResponseMessage res = GlobalVeriables.WebApiClient.GetAsync("APIQutation/" + QutationId.ToString()).Result;
MVCQutationModel qutationModel = res.Content.ReadAsAsync <MVCQutationModel>().Result;
qutationModel.Status = Status;
if (qutationModel == null)
{
return(new JsonResult {
Data = new { Status = "Fail", Message = "No record Found" }
});
}
HttpResponseMessage response = GlobalVeriables.WebApiClient.PutAsJsonAsync("APIQutation/" + QutationId, qutationModel).Result;
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
GlobalVeriables.WebApiClient.DefaultRequestHeaders.Clear();
if (qutationModel != null)
{
orderstatusModel.Fk_QutationID = qutationModel.QutationID;
orderstatusModel.Status = Status;
orderstatusModel.CreateDate = DateTime.Now;
orderstatusModel.CompanyId = Convert.ToInt32(Session["CompayID"]);
orderstatusModel.UserId = 1;
orderstatusModel.Type = "Qutation";
HttpResponseMessage response2 = GlobalVeriables.WebApiClient.PostAsJsonAsync("postOrderStatus", orderstatusModel).Result;
if (response2.StatusCode == System.Net.HttpStatusCode.OK)
{
return(new JsonResult {
Data = new { Status = "Success", Message = "Status is change successfully" }
});
}
else
{
return(new JsonResult {
Data = new { Status = "Fail", Message = "Fail to change status" }
});
}
}
}
}
catch (Exception ex)
{
return(new JsonResult {
Data = new { Status = "Fail", ex.Message }
});
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public bool AddTransaction(MVCQutationModel quatationModel)
{
bool result = false;
try
{
TransactionModel model = new TransactionModel();
model.CompanyId = (int)quatationModel.CompanyId;
model.AccountTitle = "Accounts receivable";
int AccountId = CommonController.GetAcccountId(model);
if (AccountId > 0)
{
AccountTransictionTable _TransactionTable = new AccountTransictionTable();
_TransactionTable.FK_AccountID = AccountId;
_TransactionTable.Dr = quatationModel.SubTotal;
_TransactionTable.Cr = 0;
_TransactionTable.TransictionNumber = Guid.NewGuid().ToString();
_TransactionTable.TransictionRefrenceId = quatationModel.QutationID.ToString();
_TransactionTable.CreationTime = DateTime.Now.TimeOfDay;
_TransactionTable.AddedBy = Convert.ToInt32(Session["LoginUserID"]);
_TransactionTable.FK_CompanyId = quatationModel.CompanyId;
_TransactionTable.TransictionType = "Dr";
_TransactionTable.FKPaymentTerm = null;
_TransactionTable.TransictionDate = DateTime.Now;
_TransactionTable.Description = "invoice Creating Time Transaction";
if (TransactionClass.PerformTransaction(_TransactionTable))
{
result = true;
model.AccountTitle = "Input VAT";
int AccountId1 = CommonController.GetAcccountId(model);
_TransactionTable.FK_AccountID = AccountId1;
_TransactionTable.Dr = quatationModel.TotalVat21 + quatationModel.TotalVat6;
if (TransactionClass.PerformTransaction(_TransactionTable))
{
result = true;
model.AccountTitle = "Cash on hand";
int AccountId12 = CommonController.GetAcccountId(model);
_TransactionTable.FK_AccountID = AccountId12;
_TransactionTable.Cr = quatationModel.TotalAmount;
_TransactionTable.Dr = 0;
_TransactionTable.TransictionType = "Cr";
if (TransactionClass.PerformTransaction(_TransactionTable))
{
result = true;
}
}
}
}
}
catch (Exception)
{
throw;
}
return(result);
}
public ActionResult AddPending(PendingModel pendingModel)
{
try
{
HttpResponseMessage res = GlobalVeriables.WebApiClient.GetAsync("APIQutation/" + pendingModel.Purchase_QuataionId.ToString()).Result;
MVCQutationModel puchasemodel = res.Content.ReadAsAsync <MVCQutationModel>().Result;
puchasemodel.Status = pendingModel.Status;
if (puchasemodel == null)
{
return(new JsonResult {
Data = new { Status = "Fail", Message = "No record Found" }
});
}
HttpResponseMessage response = GlobalVeriables.WebApiClient.PutAsJsonAsync("APIQutation/" + pendingModel.Purchase_QuataionId, puchasemodel).Result;
if (response.StatusCode == System.Net.HttpStatusCode.OK)
{
PendingTable pending = new PendingTable();
pending.Purchase_QuataionId = pendingModel.Purchase_QuataionId;
pending.FromDate = pendingModel.FromDate;
pending.ToDate = pendingModel.ToDate;
pending.Description = pendingModel.Description;
pending.Status = pendingModel.Status;
HttpResponseMessage postPendintTableResponse = GlobalVeriables.WebApiClient.PostAsJsonAsync("Addpending", pending).Result;
if (postPendintTableResponse.StatusCode == System.Net.HttpStatusCode.OK)
{
return(new JsonResult {
Data = new { Status = "Success", Message = "Status is change successfully to pending" }
});
}
}
else
{
return(new JsonResult {
Data = new { Status = "Fail", Message = "Fail to update status in purchase" }
});
}
}
catch (Exception ex)
{
return(new JsonResult {
Data = new { Status = "Fail", Message = ex.Message }
});
}
return(Json("", JsonRequestBehavior.AllowGet));
}
public IHttpActionResult GetQutationCount()
{
MVCQutationModel q = new MVCQutationModel();
int quataionId = db.QutationTables.ToList().Count() + 1;
q.Qutation_ID = quataionId.ToString();
if (quataionId == 0)
{
return(Ok(q));
}
else
{
return(Ok(q));
}
}
public bool Transaction(MVCQutationModel quatationModel, string TransType)
{
bool result = false;
try
{
if (TransType == "Add")
{
if (AddTransaction(quatationModel))
{
return(result = true);
}
else
{
return(result = false);
}
}
else
{
if (CommonController.DeleteFromTransactionTableByRefrenceId((int)quatationModel.QutationID))
{
if (AddTransaction(quatationModel))
{
return(result = true);
}
else
{
return(result = false);
}
}
}
}
catch (Exception)
{
result = false;
throw;
}
return(result);
}
public ActionResult ExpenseByEmail(EmailModel email, string[] Files, FormCollection formCollection)
{
var root = Server.MapPath("/PDF/");
List <AttakmentList> _attackmentList = new List <AttakmentList>();
var allowedExtensions = new string[] { "doc", "docx", "pdf", ".jpg", "png", "JPEG", "JFIF", "PNG" };
if (email.SelectList != null)
{
foreach (var item in email.SelectList)
{
if (item.IsSelected)
{
if (item.Directory.EndsWith("doc") || item.Directory.EndsWith("pdf") || item.Directory.EndsWith("docx") || item.Directory.EndsWith("jpg") || item.Directory.EndsWith("png") || item.Directory.EndsWith("txt"))
{
if (System.IO.File.Exists(Server.MapPath(item.Directory)))
{
_attackmentList.Add(new AttakmentList {
Attckment = Server.MapPath(item.Directory)
});
}
var filwe = Server.MapPath("/PDF/" + item.FileName);
if (System.IO.File.Exists(filwe))
{
_attackmentList.Add(new AttakmentList {
Attckment = filwe
});
}
}
}
}
}
if (Request.Form["FileName"] != null)
{
var fileName2 = Request.Form["FileName"];
string[] valueArray = fileName2.Split(',');
foreach (var item in valueArray)
{
if (item.EndsWith("doc") || item.EndsWith("pdf") || item.EndsWith("docx") || item.EndsWith("jpg") || item.EndsWith("png") || item.EndsWith("txt"))
{
var filwe = Server.MapPath("/PDF/" + item);
if (System.IO.File.Exists(filwe))
{
_attackmentList.Add(new AttakmentList {
Attckment = filwe
});
}
}
}
}
TempData["EmailMessge"] = "";
EmailModel emailModel = new EmailModel();
var fileName = email.Attachment;
try
{
if (email.Attachment.Contains(".pdf"))
{
email.Attachment = email.Attachment.Replace(".pdf", "");
}
if (email.ToEmail.Contains(','))
{
var p = email.Attachment.Split('.');
var pdfname = String.Format("{0}.pdf", p);
var path = Path.Combine(root, pdfname);
email.Attachment = path;
_attackmentList.Add(new AttakmentList {
Attckment = email.Attachment
});
string[] EmailArray = email.ToEmail.Split(',');
if (EmailArray.Count() > 0)
{
foreach (var item in EmailArray)
{
emailModel.From = email.From;
emailModel.ToEmail = item;
emailModel.Attachment = email.Attachment;
emailModel.EmailBody = email.EmailText;
bool result = EmailController.email(emailModel, _attackmentList);
}
}
}
else
{
var pdfname = String.Format("{0}.pdf", email.Attachment);
var path = Path.Combine(root, pdfname);
email.Attachment = path;
emailModel.From = email.From;
emailModel.ToEmail = email.ToEmail;
emailModel.Attachment = email.Attachment;
emailModel.EmailBody = email.EmailText;
_attackmentList.Add(new AttakmentList {
Attckment = emailModel.Attachment
});
bool result = EmailController.email(emailModel, _attackmentList);
TempData["EmailMessge"] = "Email Send successfully";
}
HttpResponseMessage res = GlobalVeriables.WebApiClient.GetAsync("APIQutation/" + email.invoiceId.ToString()).Result;
MVCQutationModel ob = res.Content.ReadAsAsync <MVCQutationModel>().Result;
var folderPath = Server.MapPath("/PDF/");
EmailController.clearFolder(folderPath);
return(RedirectToAction("ViewExpense", new { Id = email.invoiceId }));
}
catch (Exception ex)
{
TempData["EmailMessge"] = ex.Message.ToString();
TempData["Error"] = ex.Message.ToString();
}
if (TempData["Path"] == null)
{
TempData["Path"] = fileName;
}
TempData["Message"] = "Email Send Succssfully";
email.Attachment = fileName;
return(View(email));
}
public JsonResult Proceeds(int QutationId, string Status, string Type)
{
HttpResponseMessage responsses = new HttpResponseMessage();
MVCQutationModel QutationModel = new MVCQutationModel();
List <MVCQutationViewModel> _QuatationDetailList = new List <MVCQutationViewModel>();
InvoiceTable InvoiceTable = new InvoiceTable();
MVCInvoiceModel mvcInvoiceModel = new MVCInvoiceModel();
try
{
QutationModel = GetQutationById(QutationId);
_QuatationDetailList = GetQuatationDetailListById(QutationId);
if (QutationModel != null)
{
mvcInvoiceModel.Invoice_ID = QutationModel.Qutation_ID;
mvcInvoiceModel.QutationId = QutationModel.QutationID;
mvcInvoiceModel.CompanyId = QutationModel.CompanyId;
mvcInvoiceModel.UserId = Convert.ToInt32(Session["LoginUserID"]);
mvcInvoiceModel.ContactId = QutationModel.ContactId;
mvcInvoiceModel.InvoiceID = 0;
mvcInvoiceModel.RefNumber = QutationModel.RefNumber;
mvcInvoiceModel.InvoiceDate = QutationModel.QutationDate;
mvcInvoiceModel.InvoiceDueDate = QutationModel.DueDate;
mvcInvoiceModel.SubTotal = QutationModel.SubTotal;
mvcInvoiceModel.DiscountAmount = QutationModel.DiscountAmount;
mvcInvoiceModel.TotalAmount = QutationModel.TotalAmount;
mvcInvoiceModel.CustomerNote = QutationModel.CustomerNote;
mvcInvoiceModel.TotalVat21 = QutationModel.TotalVat21;
mvcInvoiceModel.TotalVat6 = QutationModel.TotalVat6;
mvcInvoiceModel.Type = StatusEnum.Goods.ToString();
mvcInvoiceModel.Status = "accepted";
HttpResponseMessage InvoiceResponse = GlobalVeriables.WebApiClient.PostAsJsonAsync("PostInvoice", mvcInvoiceModel).Result;
InvoiceTable = InvoiceResponse.Content.ReadAsAsync <InvoiceTable>().Result;
if (InvoiceResponse.StatusCode == System.Net.HttpStatusCode.OK)
{
if (_QuatationDetailList != null)
{
foreach (var item in _QuatationDetailList)
{
InvoiceDetailsTable InvoiceDetails = new InvoiceDetailsTable();
InvoiceDetails.ItemId = Convert.ToInt32(item.ItemId);
InvoiceDetails.InvoiceId = InvoiceTable.InvoiceID;
InvoiceDetails.Description = item.Description;
InvoiceDetails.Quantity = item.Quantity;
InvoiceDetails.Rate = Convert.ToDouble(item.Rate);
InvoiceDetails.Total = Convert.ToDouble(item.Total);
InvoiceDetails.ServiceDate = item.ServiceDate;
InvoiceDetails.RowSubTotal = item.RowSubTotal;
InvoiceDetails.Vat = Convert.ToDouble(item.Vat);
InvoiceDetails.Type = item.Type;
responsses = GlobalVeriables.WebApiClient.PostAsJsonAsync("PostinvoiceDetails", InvoiceDetails).Result;
if (responsses.StatusCode != System.Net.HttpStatusCode.OK)
{
return(new JsonResult {
Data = new { Status = "Fail", Message = "Fail to Proceed" }
});
}
}
if (UpdateQuatationStation(QutationId))
{
if (Transaction(QutationModel, "Add"))
{
return(new JsonResult {
Data = new { Status = "Success", Message = "Proceed successfullly" }
});
}
}
}
}
else
{
return(new JsonResult {
Data = new { Status = "Fail", Message = "Fail Proceed successfullly" }
});
}
}
}
catch (Exception)
{
throw;
}
return(new JsonResult {
Data = new { Status = "Success", Message = "Proceed successfullly" }
});
}
