public void BindDrpDepartment()
{
BLLCollection <Department_mst> col = new BLLCollection <Department_mst>();
Department_mst Objdepartment = new Department_mst();
int Selectedsiteval = Convert.ToInt32(DrpSite.SelectedValue);
if (Selectedsiteval == 0)
{
DrpDepartment.DataSource = col;
DrpDepartment.DataBind();
ListItem item = new ListItem();
item.Text = "--------------Select---------------";
item.Value = "0";
DrpDepartment.Items.Add(item);
DrpDepartment.SelectedValue = "0";
}
else
{
col = Objdepartment.Get_All_By_SiteId(Selectedsiteval);
DrpDepartment.DataTextField = "departmentName";
DrpDepartment.DataValueField = "deptid";
DrpDepartment.DataSource = col;
DrpDepartment.DataBind();
ListItem item = new ListItem();
item.Text = Resources.MessageResource.errSelectDept.ToString();
item.Value = "0";
DrpDepartment.Items.Add(item);
DrpDepartment.SelectedValue = "0";
}
}
public void BindDrpDepartment()
{
BLLCollection<Department_mst> col = new BLLCollection<Department_mst>();
Department_mst Objdepartment = new Department_mst();
int Selectedsiteval = Convert.ToInt16(DrpSite.SelectedValue);
if (Selectedsiteval==0)
{
DrpDepartment.DataSource = col;
DrpDepartment.DataBind();
ListItem item = new ListItem();
item.Text = "--------------Select---------------";
item.Value = "0";
DrpDepartment.Items.Add(item);
DrpDepartment.SelectedValue = "0";
}
else
{
col = Objdepartment.Get_All_By_SiteId(Selectedsiteval);
DrpDepartment.DataTextField = "departmentName";
DrpDepartment.DataValueField = "deptid";
DrpDepartment.DataSource = col;
DrpDepartment.DataBind();
ListItem item = new ListItem();
item.Text = Resources.MessageResource.errSelectDept.ToString();
item.Value = "0";
DrpDepartment.Items.Add(item);
DrpDepartment.SelectedValue = "0";
}
}
protected void departmentgrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name, desc, id;
int FlagDepartment;
int deptid;
name = ((TextBox)departmentgrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtsiteName")).Text;
desc = ((TextBox)departmentgrdvw.Rows[e.RowIndex].Cells[2].Controls[0].FindControl("txtDepartmentdesc")).Text;
id = Convert.ToString(departmentgrdvw.Rows[e.RowIndex].Cells[0].Text);
deptid = Convert.ToInt16(id);
objDepartment = objDepartment.Get_By_id(deptid);
if (objDepartment.Deptid != 0)
{
DropDownList sitedrp = ((DropDownList)departmentgrdvw.Rows[e.RowIndex].Cells[4].FindControl("drpsitename"));
int siteid = Convert.ToInt16(sitedrp.SelectedValue);
if ((objDepartment.Departmentname == name) && (objDepartment.Siteid == siteid))
{
objDepartment.Siteid = siteid;
objDepartment.Deptid = deptid;
objDepartment.Departmentname = name;
objDepartment.Description = desc;
objDepartment.Update();
departmentgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
FlagDepartment = objDepartment.Get_By_DepartmentName(name, siteid);
if ((FlagDepartment == 0) && (name != ""))
{
objDepartment.Siteid = siteid;
objDepartment.Deptid = deptid;
objDepartment.Departmentname = name;
objDepartment.Description = desc;
objDepartment.Update();
departmentgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if (name == "")
{
lblerrmsg.Text = Resources.MessageResource.errDeptName.ToString();
}
else
{
departmentgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errDepartmentExist.ToString();
}
}
}
}
string GetDepartmentName(int deptid)
{
string departmentname = "";
objDept = objDept.Get_By_id(deptid);
if (objDept.Deptid != 0)
{
departmentname = objDept.Departmentname;
}
return departmentname;
}
protected void departmentgrdvw_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string name, desc, id;
int FlagDepartment;
int deptid;
name = ((TextBox)departmentgrdvw.Rows[e.RowIndex].Cells[1].Controls[0].FindControl("txtsiteName")).Text;
desc = ((TextBox)departmentgrdvw.Rows[e.RowIndex].Cells[2].Controls[0].FindControl("txtDepartmentdesc")).Text;
id = Convert.ToString(departmentgrdvw.Rows[e.RowIndex].Cells[0].Text);
deptid = Convert.ToInt32(id);
objDepartment = objDepartment.Get_By_id(deptid);
if (objDepartment.Deptid !=0)
{
DropDownList sitedrp = ((DropDownList)departmentgrdvw.Rows[e.RowIndex].Cells[4].FindControl("drpsitename"));
int siteid = Convert.ToInt32(sitedrp.SelectedValue);
if ((objDepartment.Departmentname == name)&&(objDepartment.Siteid == siteid))
{
objDepartment.Siteid = siteid;
objDepartment.Deptid = deptid;
objDepartment.Departmentname = name;
objDepartment.Description = desc;
objDepartment.Update();
departmentgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else
{
FlagDepartment = objDepartment.Get_By_DepartmentName(name, siteid);
if ((FlagDepartment == 0)&&(name!=""))
{
objDepartment.Siteid = siteid;
objDepartment.Deptid = deptid;
objDepartment.Departmentname = name;
objDepartment.Description = desc;
objDepartment.Update();
departmentgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errupdate.ToString();
}
else if(name == "")
{
lblerrmsg.Text = Resources.MessageResource.errDeptName.ToString();
}
else
{
departmentgrdvw.EditIndex = -1;
BindGrid();
lblerrmsg.Text = Resources.MessageResource.errDepartmentExist.ToString();
}
}
}
}
public int Update_Department_mst_By_id(Department_mst objDepartment)
{
return (int)ExecuteNonQuery(Sp_Department_Update, new object[] { objDepartment.Siteid, objDepartment.Deptid, objDepartment.Departmentname, objDepartment.Description });
}
public int Insert_Department_mst(Department_mst objDepartment)
{
return (int)ExecuteNonQuery(Sp_Department_Insert, new object[] { objDepartment.Siteid, objDepartment.Deptid, objDepartment.Departmentname, objDepartment.Description, });
}
public object GenerateDepartment_mstObject(ref IDataReader returnData)
{
Department_mst obj = new Department_mst();
while (returnData.Read())
{
obj.Siteid = (int)returnData["Siteid"];
obj.Deptid = (int)returnData["Deptid"];
obj.Departmentname = (string)returnData["Departmentname"];
obj.Description = (string)returnData["Description"];
//obj.Company = (string)returnData["Company"];
}
returnData.Close();
returnData.Dispose();
return obj;
}
public CollectionBase GenerateDepartment_mstCollection(ref IDataReader returnData)
{
BLLCollection<Department_mst> col = new BLLCollection<Department_mst>();
while (returnData.Read())
{
Department_mst obj = new Department_mst();
obj.Deptid = (int)returnData["Deptid"];
obj.Departmentname = (string)returnData["Departmentname"];
obj.Siteid = (int)returnData["Siteid"];
obj.Description = (string)returnData["Description"];
//obj.Company = (string)returnData["Company"];
col.Add(obj);
}
returnData.Close();
returnData.Dispose();
return col;
}
