public bool InsertNewOtherInvoice(OtherInvoice model) { try { int status = 0; using (SqlConnection connection = DataAccess.CreateConnection()) { SqlCommand command = DataAccess.CreateCommand(connection); DataAccess.CreateStoredprocedure(command, "InsertNewOtherInvoice_SP"); DataAccess.AddInParameter(command, "AgentId", SqlDbType.Int, model.AgentId); DataAccess.AddInParameter(command, "@VendorId", SqlDbType.Int, model.VendorId); DataAccess.AddInParameter(command, "@OtherInvoiceTypeId", SqlDbType.Int, model.OtherInvoiceTypeId); DataAccess.AddInParameter(command, "@Reference", SqlDbType.VarChar, model.Reference); DataAccess.AddInParameter(command, "@ExpectedPayDate", SqlDbType.VarChar, model.ExpectedPayDate); DataAccess.AddInParameter(command, "@VendorInvNo", SqlDbType.VarChar, model.VendorInvNo); DataAccess.AddInParameter(command, "@Details", SqlDbType.VarChar, model.Details); DataAccess.AddInParameter(command, "@CustomerAgentAmount", SqlDbType.Float, model.CustomerAgentAmount); DataAccess.AddInParameter(command, "@VendorAmount", SqlDbType.Float, model.VendorAmount); DataAccess.AddInParameter(command, "@UserId", SqlDbType.VarChar, model.ApplicationUserId); status = DataAccess.ExecuteNonQuery(command); return(status < 0 ? false : true); } } catch (Exception ex) { return(false); } }
public ActionResult CreateInvoice(CreateOtherInvoice model) { if (!ModelState.IsValid) { return(RedirectToAction("CreateInvoice", "OtherInvoice")); } OtherInvoice Obj = new OtherInvoice(); Obj.AgentId = model.AgentId; Obj.ApplicationUserId = User.Identity.GetUserId(); Obj.CreatedOn = DateTime.Now; Obj.CustomerAgentAmount = model.CustomerAgentAmount; Obj.CustomerAgentPaid = false; Obj.Details = model.Details; Obj.ExpectedPayDate = model.ExpectedPayDate; Obj.OtherInvoiceTypeId = model.OtherInvoiceTypeId; Obj.Reference = model.Reference; Obj.Status = InvoiceStatus.Raised; Obj.VendorAmount = model.VendorAmount; Obj.VendorId = model.VendorId; Obj.VendorInvNo = model.VendorInvNo; Obj.VendorPaid = false; bool ret = new OtherInvoiceDA().InsertNewOtherInvoice(Obj); return(RedirectToAction("CreateInvoice", "OtherInvoice")); }