public JsonResult GetBookDtlByChallanCatIdAndLanguageId(Int32 InLanguageId, Int32 InChallanCatId) { try { List <Book_Master> lstBook = new List <Book_Master>(); DataTable dtMast = objDbTrx.GetBookDtlByChallanCatIdAndLanguageId(InLanguageId, InChallanCatId); if (dtMast.Rows.Count > 0) { for (int iCnt = 0; iCnt < dtMast.Rows.Count; iCnt++) { Book_Master onjBook_Master = new Book_Master(); onjBook_Master.BookCode = Convert.ToString(dtMast.Rows[iCnt]["BOOK_CODE"].ToString()); onjBook_Master.BookName = dtMast.Rows[iCnt]["COMMON_BOOK_CODE"].ToString() + " - " + Convert.ToString(dtMast.Rows[iCnt]["BOOK_NAME"].ToString()); lstBook.Add(onjBook_Master); } dtMast.Dispose(); } ViewBag.ObjCategoryList = new SelectList(lstBook, "BookCode", "BookName"); } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(Json(ViewBag.ObjCategoryList)); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["id"] != null) { A1 = new Book_Master(); int ID = Convert.ToInt32(Request.QueryString["id"]); show_data(ID); } } }
public ActionResult Index() { List <Book_Master> listBookMaster = new List <Book_Master>(); try { DataTable GetBookMasterdt = objDbTrx.GetBookMaster(); if (GetBookMasterdt.Rows.Count > 0) { for (int iCnt = 0; iCnt < GetBookMasterdt.Rows.Count; iCnt++) { Book_Master objMstBookMaster = new Book_Master(); objMstBookMaster.BookID = Convert.ToInt16(GetBookMasterdt.Rows[iCnt]["ID"].ToString()); objMstBookMaster.BookCode = GetBookMasterdt.Rows[iCnt]["BOOK_CODE"].ToString(); objMstBookMaster.CategoryID = Convert.ToInt16(GetBookMasterdt.Rows[iCnt]["CATEGORY_ID"].ToString()); objMstBookMaster.LanguageID = Convert.ToInt16(GetBookMasterdt.Rows[iCnt]["LANGUAGE_ID"].ToString()); objMstBookMaster.classname = GetBookMasterdt.Rows[iCnt]["CLASS"].ToString(); objMstBookMaster.BookName = GetBookMasterdt.Rows[iCnt]["BOOK_NAME"].ToString(); objMstBookMaster.rate = Convert.ToDouble(GetBookMasterdt.Rows[iCnt]["RATE"]); objMstBookMaster.quantity = Convert.ToInt16(GetBookMasterdt.Rows[iCnt]["QUANTITY"]); objMstBookMaster.unitprice = Convert.ToDouble(GetBookMasterdt.Rows[iCnt]["UNIT_PRICE"]); objMstBookMaster.challanbookcategory = Convert.ToInt16(GetBookMasterdt.Rows[iCnt]["CHALLAN_BOOK_CATEGORY_ID"].ToString()); objMstBookMaster.classinteger = Convert.ToInt16(GetBookMasterdt.Rows[iCnt]["CLASS_INT"].ToString()); objMstBookMaster.surplusquanity = GetBookMasterdt.Rows[iCnt]["SURPLUS_QTY"].ToString(); objMstBookMaster.surplusmode = GetBookMasterdt.Rows[iCnt]["SURPLUS_MODE"].ToString(); objMstBookMaster.hsnsac = GetBookMasterdt.Rows[iCnt]["HSN_SAC"].ToString(); objMstBookMaster.uqc = GetBookMasterdt.Rows[iCnt]["UQC"].ToString(); objMstBookMaster.cgstrate = GetBookMasterdt.Rows[iCnt]["CGST_RATE"].ToString(); objMstBookMaster.sgstrate = GetBookMasterdt.Rows[iCnt]["SGST_RATE"].ToString(); objMstBookMaster.igstrate = GetBookMasterdt.Rows[iCnt]["IGST_RATE"].ToString(); objMstBookMaster.booknamedescription = GetBookMasterdt.Rows[iCnt]["BOOK_NAME_DESC"].ToString(); objMstBookMaster.Bookweight = Convert.ToDouble(GetBookMasterdt.Rows[iCnt]["Book_Weight"].ToString()); objMstBookMaster.BookcategoryName = GetBookMasterdt.Rows[iCnt]["BOOK_CATEGORY"].ToString(); objMstBookMaster.ChallanBookcategoryName = GetBookMasterdt.Rows[iCnt]["CHALLAN_BOOK_CATEGORY"].ToString(); objMstBookMaster.LanguageName = GetBookMasterdt.Rows[iCnt]["LANGUAGE"].ToString(); objMstBookMaster.Book_Lock = Convert.ToBoolean(GetBookMasterdt.Rows[iCnt]["Book_Lock"]); listBookMaster.Add(objMstBookMaster); } } } catch (Exception ex) { objDbTrx.SaveSystemErrorLog(ex, Request.UserHostAddress); } return(View(listBookMaster)); }
public void show_data(int ID) { A_Handler = new Book_MasterHandler(); A1 = new Book_Master(); A1 = A_Handler.GetBook_MasterDetails(ID); txtBook_id.Text = A1.Book_id.ToString(); ddlReg_id.Text = A1.Reg_id.ToString(); txtPdate.Text = A1.Pdate.ToString(); txtAuthor.Text = A1.Author.ToString(); txtTitle.Text = A1.Title.ToString(); txtSubject.Text = A1.Subject.ToString(); DropDownList1.Text = A1.Book_type.ToString(); txtEdition.Text = A1.Edition.ToString(); txtPublisher_place.Text = A1.Publisher_place.ToString(); txtPublisher.Text = A1.Publisher.ToString(); txtYear.Text = A1.Year.ToString(); txtPages.Text = A1.Pages.ToString(); txtVolume.Text = A1.Volume.ToString(); txtSource.Text = A1.Source.ToString(); txtCost.Text = A1.Cost.ToString(); txtBill_no.Text = A1.Bill_no.ToString(); txtBook_no.Text = A1.Book_no.ToString(); txtMore_info.Text = A1.More_info.ToString(); // txtPhoto.Text = A1.Photo.ToString(); if (A1.Photo.ToString() != null) { Image1.ImageUrl = ("~/img/" + A1.Photo.ToString());; } else { Image1.ImageUrl = ("~/img/000.jpg"); } btnSubmit.Text = "Update"; btnReset.Text = "Cancel"; if (Request.QueryString["action"] == "del") { Label1.Text = "Are U Sure, U want to Delete a Record ?"; txtBook_id.ReadOnly = false; ddlReg_id.Enabled = false; txtPdate.ReadOnly = true; txtAuthor.ReadOnly = false; txtTitle.ReadOnly = false; txtSubject.ReadOnly = false; DropDownList1.Enabled = false; txtEdition.ReadOnly = false; txtPublisher_place.ReadOnly = false; txtPublisher.ReadOnly = false; txtYear.ReadOnly = false; txtPages.ReadOnly = false; txtVolume.ReadOnly = false; txtSource.ReadOnly = false; txtCost.ReadOnly = false; txtBill_no.ReadOnly = false; txtBook_no.ReadOnly = false; txtMore_info.ReadOnly = false; FileUpload1.Enabled = false; btnSubmit.Text = "Delete"; } }
protected void btnSubmit_Click(object sender, EventArgs e) { A_Handler = new Book_MasterHandler(); A1 = new Book_Master(); //A1.Book_id = Convert.ToInt32(txtBook_id.Text); A1.Reg_id = Convert.ToInt32(ddlReg_id.SelectedValue); A1.Pdate = Convert.ToDateTime(txtPdate.Text); A1.Author = txtAuthor.Text; A1.Title = txtTitle.Text; A1.Subject = txtSubject.Text; A1.Book_type = DropDownList1.Text; A1.Edition = txtEdition.Text; A1.Publisher_place = txtPublisher_place.Text; A1.Publisher = txtPublisher.Text; A1.Year = Convert.ToInt32(txtYear.Text); A1.Pages = Convert.ToInt32(txtPages.Text); A1.Volume = txtVolume.Text; A1.Source = txtSource.Text; A1.Cost = Convert.ToDecimal(txtCost.Text); A1.Bill_no = Convert.ToInt32(txtBill_no.Text); A1.Book_no = Convert.ToInt32(txtBook_no.Text); A1.More_info = txtMore_info.Text; // A1.Photo = txtPhoto.Text; A1.Photo = "000.jpg"; if (FileUpload1.HasFile == true) { FileUpload1.SaveAs(Server.MapPath("~/img") + "/" + FileUpload1.FileName); A1.Photo = FileUpload1.FileName; } if (btnSubmit.Text == "Submit") { bool B = A_Handler.AddNewBook_Master(A1); if (B == true) { Label1.Text = "Record Inserted"; MSG = "Record Inserted"; } else { Label1.Text = "Record Not Inserted"; MSG = "Record Not Inserted"; } } else if (btnSubmit.Text == "Update") { A1.Book_id = Convert.ToInt32(txtBook_id.Text); bool B = A_Handler.UpdateBook_Master(A1); if (B == true) { Label1.Text = "Record Updated"; MSG = "Record Not Updated"; } else { Label1.Text = "Record Not Updated"; MSG = "Record Not Updated"; } } else if (btnSubmit.Text == "Delete") { A1.Book_id = Convert.ToInt32(txtBook_id.Text); bool B = A_Handler.DeleteBook_Master(A1); if (B == true) { Label1.Text = "Record Deleted"; MSG = "Record Deleted"; } else { Label1.Text = "Record Not Deleted"; MSG = "Record Not Deleted"; } } //Response.Redirect("~/ADMIN/Book_Master_list.aspx?msg="+MSG); }
// This fuction does not contain any business logic, it simply returns the // list of book_masters, we can put some logic here if needed public bool AddNewBook_Master(Book_Master b1) { return(book_masterDb.AddNewBook_Master(b1)); }
// This fuction does not contain any business logic, it simply returns the // list of book_masters, we can put some logic here if needed public bool DeleteBook_Master(Book_Master b1) { return(book_masterDb.DeleteBook_Master(b1)); }
// This fuction does not contain any business logic, it simply returns the // list of book_masters, we can put some logic here if needed public bool UpdateBook_Master(Book_Master b1) { return(book_masterDb.UpdateBook_Master(b1)); }