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));
}
