public void DeleteInfo(clsDept dept)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = @"update dept_info set [DeleteBy]='" + dept.LoginBy +
"',[DeleteDate]=GetDate() where [DEPT_ID]='" + dept.DeptId + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public void GetData()
{
clsDept obj = new clsDept();
ddlDeptName.DataSource = obj.GetDept();
ddlDeptName.DataTextField = "DeptName";
ddlDeptName.DataValueField = "DeptId";
ddlDeptName.DataBind();
ddlDeptName.Items.Insert(0, "--------Select---------");
}
private void GetDepartments()
{
objDept = new clsDept();
DataSet ds = objDept.GetDeptID();
ddlDept.DataSource = ds.Tables[0];
ddlDept.DataTextField = "DeptName";
ddlDept.DataValueField = "DepartmentId";
ddlDept.DataBind();
ddlDept.Items.Insert(0, "--Select One--");
}
public void UpdateDepartment(clsDept aclsDept)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = @"UPDATE [Department]
SET [DEPT_CODE] ='" + aclsDept.DeptId + "' ,[DEPT_NAME] ='" + aclsDept.DeptName + "',[ABVR] ='" + aclsDept.Abvr +
"' ,[UpdateBy] ='" + aclsDept.LoginBy + "' ,[UpdateDate] =GETDATE() WHERE ID='" + aclsDept.ID +
"'";
DataManager.ExecuteNonQuery(connectionString, query);
}
private void GetDesignation()
{
objDept = new clsDept();
DataSet ds = objDept.GetDesignation();
Cache["DesgData"] = ds;
ddlDesg.DataSource = ds.Tables[0];
ddlDesg.DataTextField = "Desg_Name";
ddlDesg.DataValueField = "DesignationId";
ddlDesg.DataBind();
ddlDesg.Items.Insert(0, "--Select One--");
}
public static void UpdateDept(clsDept dept)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = @"update dept_info set dept_name='" + dept.DeptName + "',abvr='" + dept.Abvr +
"', credit=convert(decimal,'" + dept.Credit + "'),costs=convert(decimal,'" + dept.Costs +
"'),[SEMISTERFEE] = convert(decimal,'" + dept.SEMISTERFEE +
"'),[ADMISSIONFEE] = convert(decimal,'" + dept.ADMISSIONFEE + "'),[NOOFSEMI] = convert(int,'" +
dept.NOOFSEMI + "'),[SEMIHIGHCREDIT] = convert(decimal,'" + dept.SEMIHIGHCREDIT +
"'),[PERCREDITCOST] = convert(decimal,'" + dept.PERCREDITCOST + "') where dept_id='" +
dept.DeptId + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
//***************************** Insert Department ************************//
public void SaveDepartment(clsDept aclsDept)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = @"INSERT INTO [Department]
([DEPT_CODE]
,[DEPT_NAME]
,[ABVR],[AddBy],[AddDate])
VALUES
('" + aclsDept.DeptId + "','" + aclsDept.DeptName + "','" + aclsDept.Abvr + "','" + aclsDept.LoginBy +
"',GETDATE())";
DataManager.ExecuteNonQuery(connectionString, query);
}
public void UpdateInfo(clsDept aDept)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = @"update dept_info set dept_name='" + aDept.DeptName + "',abvr='" + aDept.Abvr +
"', credit='" + aDept.Credit.Replace(",", "") + "',costs='" + aDept.Costs.Replace(",", "") +
"',[SEMISTERFEE] = '" + aDept.SEMISTERFEE.Replace(",", "") + "',[ADMISSIONFEE] = '" +
aDept.ADMISSIONFEE.Replace(",", "") + "',[NOOFSEMI] = convert(int,'" + aDept.NOOFSEMI +
"'),[SEMIHIGHCREDIT] = '" + aDept.SEMIHIGHCREDIT.Replace(",", "") + "',[PERCREDITCOST] = '" +
aDept.PERCREDITCOST.Replace(",", "") + "',[UpdateBy]='" + aDept.LoginBy +
"',[UpdateDate]=GetDate(),Dept_MstID='" + aDept.DeptId + "' where dept_id='" + aDept.ID + "'";
DataManager.ExecuteNonQuery(connectionString, query);
}
public static void CreateDept(clsDept dept)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = @"insert into dept_info (dept_id, dept_name,abvr,costs,credit,[SEMISTERFEE]
,[ADMISSIONFEE]
,[NOOFSEMI]
,[SEMIHIGHCREDIT]
,[PERCREDITCOST]) values ('" + dept.DeptId + "','" + dept.DeptName + "','" + dept.Abvr +
"',convert(decimal,'" + dept.Costs + "'),'" + dept.Credit + "','" + dept.SEMISTERFEE + "','" +
dept.ADMISSIONFEE + "','" + dept.NOOFSEMI + "','" + dept.SEMIHIGHCREDIT + "','" +
dept.PERCREDITCOST + "')";
DataManager.ExecuteNonQuery(connectionString, query);
}
public void SaveInfo(clsDept aDept)
{
string connectionString = DataManager.OraConnString();
SqlConnection sqlCon = new SqlConnection(connectionString);
string query = @"insert into dept_info (dept_name,abvr,costs,credit,[SEMISTERFEE]
,[ADMISSIONFEE]
,[NOOFSEMI]
,[SEMIHIGHCREDIT]
,[PERCREDITCOST]
,[AddBy]
,[AddDate],Dept_MstID) values ('" + aDept.DeptName + "','" + aDept.Abvr + "','" +
aDept.Costs.Replace(",", "") + "','" + aDept.Credit + "','" + aDept.SEMISTERFEE + "','" +
aDept.ADMISSIONFEE + "','" + aDept.NOOFSEMI + "','" + aDept.SEMIHIGHCREDIT + "','" +
aDept.PERCREDITCOST + "','" + aDept.LoginBy + "',GetDate(),'" + aDept.DeptId + "')";
DataManager.ExecuteNonQuery(connectionString, query);
}
