public int CheckGroupName_DL(EWA_AddBookGroup objEWA)
{
DataSet ds = new DataSet();
int cnt = 0;
try
{
prmList = new string[6];
prmList[0] = "@Action";
prmList[1] = "CheckGroupName";
prmList[2] = "@GroupName";
prmList[3] = objEWA.GroupName;
prmList[4] = "@GroupId";
prmList[5] = objEWA.GroupId.ToString();
ds = ObjHelper.FillControl(prmList, "SP_LibAddGroup");
if (ds.Tables[0].Rows.Count > 0)
{
cnt = Convert.ToInt32(ds.Tables[0].Rows[0][0].ToString());
}
}
catch (Exception ex)
{
}
return(cnt);
}
public DataSet GetBookGroup_DL(EWA_AddBookGroup 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_LibAddGroup");
if (ds.Tables[0].Rows.Count <= 0)
{
DataTable dt = new DataTable();
dt.Columns.Add("GroupId");
dt.Columns.Add("GroupCode");
dt.Columns.Add("GroupName");
//dt.Rows.Add();
//dt.Rows.Add();
//dt.Rows.Add();
//ds.Tables.RemoveAt(0);
//ds.Tables.Add(dt);
}
}
catch (Exception ex)
{
}
return(ds);
}
public int BookGroupAction_DL(EWA_AddBookGroup objEWA)
{
int flag = 0;
try
{
cmd = new SqlCommand("SP_LibAddGroup", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Action", objEWA.Action);
cmd.Parameters.AddWithValue("@GroupId", objEWA.GroupId);
cmd.Parameters.AddWithValue("@GroupCode", objEWA.GroupCode);
cmd.Parameters.AddWithValue("@GroupName", objEWA.GroupName);
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);
}
public int CheckGroupName_BL(EWA_AddBookGroup objEWA)
{
int cnt = objDL.CheckGroupName_DL(objEWA);
return(cnt);
}
public DataSet GetBookGroup_BL(EWA_AddBookGroup objEWA)
{
DataSet ds = objDL.GetBookGroup_DL(objEWA);
return(ds);
}
public int BookGroupAction_BL(EWA_AddBookGroup objEWA)
{
int flag = objDL.BookGroupAction_DL(objEWA);
return(flag);
}
private void Action(string strAction)
{
try
{
objEWA = new EWA_AddBookGroup();
objEWA.Action = strAction;
objEWA.GroupId = Convert.ToInt32(ViewState["GroupId"].ToString());
objEWA.GroupCode = Convert.ToString(ViewState["GroupCode"]);
objEWA.GroupName = txtGroupName.Text.ToString();
objEWA.OrgId = orgId;
objEWA.UserId = Convert.ToInt32(Session["UserCode"].ToString());
objEWA.IsActive = "true";
if (CheckGroupName(objEWA) > 0)
{
msgBox.ShowMessage("Record Already Exist !!!", "Information", UserControls.MessageBox.MessageStyle.Information);
return;
}
int flag = objBL.BookGroupAction_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);
}
txtGroupName.Text = "";
DisableCntrl();
GetBookGroup();
}
else if (flag == -1)
{
if (strAction == "Delete")
{
msgBox.ShowMessage("Record is in Used !!!", "Critical", UserControls.MessageBox.MessageStyle.Critical);
}
}
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)
{
}
}
private int CheckGroupName(EWA_AddBookGroup objEWA)
{
int cnt = objBL.CheckGroupName_BL(objEWA);
return(cnt);
}
