protected void btnSave_Click(object sender, EventArgs e) { if (IsDuplicateInvoiceNo()) { lblMessage.Text = string.Format("The Invoice No {0} already exist. Please try with another Invoice No", txtInvoiceNo.Text); return; } using (TheFacade facade = new TheFacade()) { if (InvoiceId <= 0) { Inv_Master invoice = new Inv_Master(); invoice.CurrencyId = Convert.ToInt32(ddlCurrency.SelectedValue); //invoice.Date = Convert.ToDateTime(txtDate.Text); //DateTime dt = DateTime.ParseExact(txtDate.Text, "dd/M/yyyy", CultureInfo.InvariantCulture); //invoice.Date = dt;// invoice.Date = Convert.ToDateTime(txtDate.Text); invoice.DollarAmount = 0;//will be updated later invoice.DollarCounversionRate = Convert.ToDecimal(txtConversionRate.Text); invoice.Number = txtInvoiceNo.Text; invoice.CreateBy = 1;//sustemuserid invoice.CreateDate = DateTime.Now; invoice.IsRemoved = 0; invoice.UpdateBy = 1;//sustemuserid invoice.UpdateDate = DateTime.Now; invoice.MemberId = MemberID; invoice.ExportedLocalItemDescription = txtLocalItemDescription.Text; invoice.ExportedLocalItemQuantity = txtLoacItemQuantity.Text; invoice.ExportedLocalItemAmount = Convert.ToDecimal(txtLocalItemAmount.Text); invoice.ExportedLocalDistrubuterNameAndAddress = txtLocalDistrubuterNameAndAddress.Text; invoice.CountryID = Convert.ToInt64(ddlCountry.SelectedValue.ToString()); try { facade.Insert <Inv_Master>(invoice); SaveUpdateInvoiceDetail(invoice.IID, facade); InvoiceId = invoice.IID; } catch (Exception ex) { if (ex.Message.Contains("Violation of UNIQUE KEY constraint")) { lblMessage.Text = "Please Insert Unique Invoice Number"; } else { lblMessage.Text = "Data Not Successfully Saved"; } } } else { Inv_Master invoice = facade.InvoiceFacade.GetInvoiceByIDForUpdate(InvoiceId); invoice.CurrencyId = Convert.ToInt32(ddlCurrency.SelectedValue); //DateTime dt = DateTime.ParseExact(txtDate.Text, "dd/MM/yyyy", CultureInfo.InvariantCulture); //invoice.Date = dt;// Convert.ToDateTime(txtDate.Text); invoice.Date = Convert.ToDateTime(txtDate.Text); invoice.DollarAmount = 0;;//will be updated later invoice.DollarCounversionRate = Convert.ToDecimal(txtConversionRate.Text); invoice.Number = txtInvoiceNo.Text; invoice.UpdateBy = 1;//sustemuserid invoice.UpdateDate = DateTime.Now; invoice.MemberId = MemberID; invoice.ExportedLocalItemDescription = txtLocalItemDescription.Text; invoice.ExportedLocalItemQuantity = txtLoacItemQuantity.Text; invoice.ExportedLocalItemAmount = Convert.ToDecimal(txtLocalItemAmount.Text); invoice.ExportedLocalDistrubuterNameAndAddress = txtLocalDistrubuterNameAndAddress.Text; invoice.CountryID = Convert.ToInt64(ddlCountry.SelectedValue.ToString()); facade.Update <Inv_Master>(invoice); SaveUpdateInvoiceDetail(invoice.IID, facade); } UpdateDollarAmount(facade, InvoiceId); } //Response.Redirect(Request.Url.ToString()); //SHUVO string redirectUrl = Request.Url.GetLeftPart(UriPartial.Path).ToString() + "?invId=" + InvoiceId.ToString(); Response.Redirect(redirectUrl); }
protected void btnUpload_Click(object sender, EventArgs e) { if (fuEnclosedDoc.HasFile && !string.IsNullOrEmpty(txtDocumentName.Text)) { string fileExtention = Path.GetExtension(fuEnclosedDoc.FileName); string path = string.Format("~/MemberData/InvoiceEnclosedDocument/{0}/", InvoiceId.ToString()); string fileName = Server.MapPath(path) + txtDocumentName.Text + fileExtention; if (CurrentDocumentID <= 0) { try { if (!Directory.Exists(Server.MapPath(path))) { Directory.CreateDirectory(Server.MapPath(path)); } fuEnclosedDoc.SaveAs(fileName); using (TheFacade facade = new TheFacade()) { Ins_InvoiceEnclosedDocument document = new Ins_InvoiceEnclosedDocument(); document.Name = txtDocumentName.Text; document.FileName = txtDocumentName.Text + fileExtention; document.Path = path + document.FileName; document.InvoiceID = InvoiceId; document.CreatedDate = DateTime.Now; facade.Insert <Ins_InvoiceEnclosedDocument>(document); } } catch (Exception ex) { } } else { using (TheFacade facade = new TheFacade()) { Ins_InvoiceEnclosedDocument document = facade.InsentiveFacade.GetInvoiceEnclosedDocumentByID(CurrentDocumentID); string existingFile = Server.MapPath(path) + document.FileName; if (File.Exists(existingFile)) { File.Delete(existingFile); } if (!Directory.Exists(Server.MapPath(path))) { Directory.CreateDirectory(Server.MapPath(path)); } fuEnclosedDoc.SaveAs(fileName); document.Name = txtDocumentName.Text; document.FileName = txtDocumentName.Text + fileExtention; document.Path = path + document.FileName; document.InvoiceID = InvoiceId; document.CreatedDate = DateTime.Now; facade.Update <Ins_InvoiceEnclosedDocument>(document); } } } //CurrentDocumentID = 0; //txtDocumentName.Text = string.Empty; //LoadInvoiceEnclosedDocument(); Response.Redirect(Request.Url.ToString()); }