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