private void GetBookInfo() { try { ds = new DataSet(); objBL = new BL_IssueBook(); objEWA = new EWA_IssueBook(); objEWA.BookId = Convert.ToInt32(ddlBookName.SelectedValue.ToString()); ds = objBL.GetBookInfo_BL(objEWA); if (ds.Tables[0].Rows.Count > 0) { txtAuthor.Text = ds.Tables[0].Rows[0]["Author"].ToString(); txtPublisher.Text = ds.Tables[0].Rows[0]["Publisher"].ToString(); txtPublishYear.Text = ds.Tables[0].Rows[0]["PublishingYear"].ToString(); txtEdition.Text = ds.Tables[0].Rows[0]["Edition"].ToString(); txtPrice.Text = ds.Tables[0].Rows[0]["Price"].ToString(); float stock = db.getDb_Value("select qty from tblLibAddBook where BookId='" + objEWA.BookId + "' and OrgId='" + Convert.ToInt32(Session["OrgId"]) + "'"); lblstock.Text = stock.ToString(); } else { txtAuthor.Text = ""; txtPublisher.Text = ""; txtPublishYear.Text = ""; txtEdition.Text = ""; txtPrice.Text = ""; } } catch (Exception ex) { } }
public int IssueBookAction_DL(EWA_IssueBook objEWA) { int flag = 0; try { cmd = new SqlCommand("SP_LibIssueBook", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@Action", objEWA.Action); cmd.Parameters.AddWithValue("@IssueId", objEWA.IssueId); cmd.Parameters.AddWithValue("@BookId", objEWA.BookId); cmd.Parameters.AddWithValue("@GroupId", objEWA.GroupId); cmd.Parameters.AddWithValue("@StudentId", objEWA.StudentId); cmd.Parameters.AddWithValue("@IssueDate", objEWA.IssueDate); cmd.Parameters.AddWithValue("@DueDate", objEWA.DueDate); cmd.Parameters.AddWithValue("@OrgId", objEWA.OrgId); cmd.Parameters.AddWithValue("@UserId", objEWA.UserId); cmd.Parameters.AddWithValue("@IsActive", objEWA.IsActive); con.Open(); flag = cmd.ExecuteNonQuery(); con.Close(); } catch (Exception) { } return(flag); }
protected void txtIssueTo_TextChanged(object sender, EventArgs e) { ds = new DataSet(); objBL = new BL_IssueBook(); objEWA = new EWA_IssueBook(); objEWA.StudentCode = txtIssueTo.Text.ToString(); ds = objBL.GetStudentInfo_BL(objEWA); if (ds.Tables[0].Rows.Count > 0) { ViewState["StudentId"] = ds.Tables[0].Rows[0]["StudentId"].ToString(); txtIssueName.Text = ds.Tables[0].Rows[0]["StdName"].ToString(); } else { ViewState["StudentId"] = "0"; txtIssueName.Text = ""; } }
public DataSet GetBookGroup_DL(EWA_IssueBook objEWA) { DataSet ds = new DataSet(); try { prmList = new string[4]; prmList[0] = "@Action"; prmList[1] = "GetGroup"; prmList[2] = "@OrgId"; prmList[3] = objEWA.OrgId.ToString(); ds = ObjHelper.FillControl(prmList, "SP_LibIssueBook"); } catch (Exception ex) { } return(ds); }
private void GetBook() { try { ds = new DataSet(); objBL = new BL_IssueBook(); objEWA = new EWA_IssueBook(); objEWA.GroupId = Convert.ToInt32(ddlGroupName.SelectedValue.ToString()); ds = objBL.GetBook_BL(objEWA); ddlBookName.DataSource = ds; ddlBookName.DataValueField = "BookId"; ddlBookName.DataTextField = "BookName"; ddlBookName.DataBind(); ddlBookName.Items.Insert(0, new ListItem("Select", "0")); } catch (Exception ex) { } }
public DataSet GetStudentInfo_DL(EWA_IssueBook objEWA) { DataSet ds = new DataSet(); try { prmList = new string[4]; prmList[0] = "@Action"; prmList[1] = "GetStudentInfo"; prmList[2] = "@StudentCode"; prmList[3] = objEWA.StudentCode; ds = ObjHelper.FillControl(prmList, "SP_LibIssueBook"); } catch (Exception ex) { } return(ds); }
public DataSet GetIsueeBook_DL(EWA_IssueBook objEWA) { DataSet ds = new DataSet(); try { prmList = new string[4]; prmList[0] = "@Action"; prmList[1] = "GetData"; prmList[2] = "@OrgId"; prmList[3] = objEWA.OrgId.ToString(); ds = ObjHelper.FillControl(prmList, "SP_LibIssueBook"); if (ds.Tables[0].Rows.Count <= 0) { DataTable dt = new DataTable(); dt.Columns.Add("IssueId"); dt.Columns.Add("IssueDate"); dt.Columns.Add("DueDate"); dt.Columns.Add("BookId"); dt.Columns.Add("BookName"); dt.Columns.Add("GroupId"); dt.Columns.Add("GroupName"); dt.Columns.Add("PublishingYear"); dt.Columns.Add("StudentId"); dt.Columns.Add("StdName"); //dt.Rows.Add(); //dt.Rows.Add(); //dt.Rows.Add(); //ds.Tables.RemoveAt(0); //ds.Tables.Add(dt); } } catch (Exception ex) { } return(ds); }
public DataSet GetStudentInfo_BL(EWA_IssueBook objEWA) { DataSet ds = objDL.GetStudentInfo_DL(objEWA); return(ds); }
public DataSet GetBook_BL(EWA_IssueBook objEWA) { DataSet ds = objDL.GetBook_DL(objEWA); return(ds); }
public int IssueBookAction_BL(EWA_IssueBook objEWA) { int flag = objDL.IssueBookAction_DL(objEWA); return(flag); }
private void Action(string strAction) { try { objEWA = new EWA_IssueBook(); objEWA.Action = strAction; objEWA.IssueId = Convert.ToInt32(ViewState["IssueId"].ToString()); objEWA.BookId = Convert.ToInt32(ddlBookName.SelectedValue.ToString()); objEWA.GroupId = Convert.ToInt32(ddlGroupName.SelectedValue.ToString()); objEWA.StudentId = Convert.ToInt32(ViewState["StudentId"].ToString()); objEWA.IssueDate = txtIssueDate.Text.ToString(); //System.Data.SqlTypes.SqlDateTime.Parse(txtIssueDate.Text).ToString(); objEWA.DueDate = txtDueDate.Text.ToString(); //System.Data.SqlTypes.SqlDateTime.Parse(txtDueDate.Text).ToString(); objEWA.OrgId = orgId; objEWA.UserId = Convert.ToInt32(Session["UserCode"].ToString()); objEWA.IsActive = "true"; //if (CheckBookName(objEWA) > 0) //{ // msgBox.ShowMessage("Record Already Exist !!!", "Information", UserControls.MessageBox.MessageStyle.Information); // return; //} int flag = objBL.IssueBookAction_BL(objEWA); if (flag > 0) { if (strAction == "Save") { msgBox.ShowMessage("Record Saved Successfully !!!", "Saved", UserControls.MessageBox.MessageStyle.Successfull); } else if (strAction == "Update") { msgBox.ShowMessage("Record Updated Successfully !!!", "Updated", UserControls.MessageBox.MessageStyle.Successfull); } else if (strAction == "Delete") { msgBox.ShowMessage("Record Deleted Successfully !!!", "Deleted", UserControls.MessageBox.MessageStyle.Successfull); } ClearCntrl(); DisableCntrl(); GetIsueeBook(); } else { if (strAction == "Save") { msgBox.ShowMessage("already exists cann't Save !!!", "Critical", UserControls.MessageBox.MessageStyle.Critical); } else if (strAction == "Update") { msgBox.ShowMessage("Unable to Update !!!", "Critical", UserControls.MessageBox.MessageStyle.Critical); } else if (strAction == "Delete") { msgBox.ShowMessage("Unable to Delete !!!", "Critical", UserControls.MessageBox.MessageStyle.Critical); } } } catch (Exception) { } }