public static List <ISettlement> GetAllSettlements(SearchCriteria searchCriteria, int locationId) { string strExecution = "[uspGetSettlement]"; List <ISettlement> lstBL = new List <ISettlement>(); using (DbQuery oDq = new DbQuery(strExecution)) { //oDq.AddIntegerParam("@pk_SettlementID", searchCriteria.IntegerOption1); oDq.AddIntegerParam("@Locationid", searchCriteria.LocationID); oDq.AddVarcharParam("@SchBLNo", 100, searchCriteria.BLNo); oDq.AddVarcharParam("@SchLine", 100, searchCriteria.LineName); oDq.AddVarcharParam("@SchLocation", 100, searchCriteria.LocName); oDq.AddVarcharParam("@SchSettlementNo", 100, searchCriteria.BookingNo); oDq.AddVarcharParam("@SortExpression", 100, searchCriteria.SortExpression); oDq.AddVarcharParam("@SortDirection", 100, searchCriteria.SortDirection); DataTableReader reader = oDq.GetTableReader(); while (reader.Read()) { ISettlement bl = new SettlementEntity(reader); lstBL.Add(bl); } reader.Close(); } return(lstBL); }
protected void btnSave_Click(object sender, EventArgs e) { try { //string misc = string.Empty; if (txtPayToRcvdFrom.Text != hdnCustName.Value && CLUpload.HasFile == false) { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('Consignee Letter Upload is compulsory!');</script>", false); return; } if (txtChequeDate.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('Cheque Date is compulsory!');</script>", false); return; } if (txtChequeDetail.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('Cheque No is compulsory!');</script>", false); return; } if (txtBankName.Text == "") { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('BankName is compulsory!');</script>", false); return; } if (RRUpload.HasFile) { var fileName = RRUpload.FileName; var filext = fileName.Substring(fileName.LastIndexOf(".") + 1); if (filext.ToLower() != "pdf") { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('Only pdf file is accepted!');</script>", false); return; } var path = Server.MapPath("~/Transaction/SettlementDocs"); var newFileName = "RR" + txtBlNo; // Guid.NewGuid().ToString(); if (!string.IsNullOrEmpty(path)) { path += @"\" + newFileName + System.IO.Path.GetExtension(fileName); hdnRRPath.Value = path; RRUpload.PostedFile.SaveAs(path); } } if (CLUpload.HasFile) { var fileName = CLUpload.FileName; var filext = fileName.Substring(fileName.LastIndexOf(".") + 1); if (filext.ToLower() != "pdf") { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('Only pdf file is accepted!');</script>", false); return; } var path = Server.MapPath("~/Transaction/SettlementDocs"); var newFileName = "CL" + txtBlNo; // Guid.NewGuid().ToString(); if (!string.IsNullOrEmpty(path)) { path += @"\" + newFileName + System.IO.Path.GetExtension(fileName); hdnCLPath.Value = path; CLUpload.PostedFile.SaveAs(path); } } ISettlement Settlement = new SettlementEntity(); BuildSettlementEntity(Settlement); long Settlementid = new SettlementBLL().SaveSettlement(Settlement); ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('Record saved successfully!');</script>", false); if (!ReferenceEquals(Request.QueryString["id"], null)) { Response.Redirect("~/Transaction/Settlement1.aspx"); } else { Response.Redirect("~/Transaction/Settlement1.aspx"); } //ClearAll(); //if (isedit == true) // Response.Redirect("~/Export/Voyage.aspx"); //else // clearPage(); } catch (Exception ex) { ScriptManager.RegisterStartupScript(this, typeof(Page), "alert", "<script>javascript:void alert('Record could not be saved due to ! " + ex.Message.ToString() + "');</script>", false); } }