public DataTable PopulateFrameworkDetails(FrameworkBO objFrameworkBo)
{
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_PROJECT.PR_POPULATE_FRAMEWORK_DETAILS", objFrameworkBo.FrameworkId, OracleDbType.RefCursor);
DataTable dt = null;
DataSet ds = null;
ds = db.ExecuteDataSet(cmd);
if (ds != null && ds.Tables.Count > 0)
{
dt = ds.Tables[0];
}
return(dt);
}
private void PopulateAllFrameworks()
{
lvFramework.DataSource = null;
lvFramework.DataBind();
objFrameworkBo = new FrameworkBO();
wbs = new FrameworkManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationFramework();
dtFrameworks = wbs.PopulateAllFrameworks();
if (dtFrameworks != null && dtFrameworks.Rows.Count > 0)
{
lvFramework.DataSource = dtFrameworks;
lvFramework.DataBind();
}
}
private void PopulateFrameworkDetails(int frameworkId)
{
objFrameworkBO = new FrameworkBO();
objFrameworkBO.FrameworkId = frameworkId;
objFramework = new FrameworkManagementService();
objFramework.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationFramework();
dtFramework = objFramework.PopulateFrameworkDetails(objFrameworkBO);
if (dtFramework != null && dtFramework.Rows.Count > 0)
{
ddlBaseYear.SelectedValue = dtFramework.Rows[0]["BASE_YEAR_ID"].ToString();
ddlFirstYear.SelectedValue = dtFramework.Rows[0]["FIRST_YEAR_ID"].ToString();
ddlSecondYear.SelectedValue = dtFramework.Rows[0]["SECOND_YEAR_ID"].ToString();
ddlThirdYear.SelectedValue = dtFramework.Rows[0]["THIRD_YEAR_ID"].ToString();
}
}
public int AddEditFramework(FrameworkBO objFrameworkBO)
{
int i = 0;
DbCommand cmd = null;
cmd = db.GetStoredProcCommand("PKG_PROJECT.PR_ADD_EDIT_FRAMEWORK");
db.AddInParameter(cmd, "V_MODE", DbType.String, objFrameworkBO.Mode);
db.AddInParameter(cmd, "V_FRAMEWORK_ID", DbType.Int32, objFrameworkBO.FrameworkId);
db.AddInParameter(cmd, "V_FRAMEWORK_ENG_NAME", DbType.String, objFrameworkBO.FrameworkEngName);
db.AddInParameter(cmd, "V_FRAMEWORK_NEP_NAME", DbType.String, objFrameworkBO.FrameworkNepName);
db.AddInParameter(cmd, "V_BASE_YEAR_ID", DbType.Int32, objFrameworkBO.BaseYearId);
db.AddInParameter(cmd, "V_FIRST_YEAR_ID", DbType.Int32, objFrameworkBO.FirstYearId);
db.AddInParameter(cmd, "V_SECOND_YEAR_ID", DbType.Int32, objFrameworkBO.SecondYearId);
db.AddInParameter(cmd, "V_THIRD_YEAR_ID", DbType.Int32, objFrameworkBO.ThirdYearId);
db.AddInParameter(cmd, "V_IS_ENABLE", DbType.Int32, objFrameworkBO.IsEnable);
db.AddInParameter(cmd, "V_IS_LOCKED", DbType.Int32, objFrameworkBO.IsLocked);
i = db.ExecuteNonQuery(cmd);
return(i);
}
protected void btnAddFramework_Click(object sender, EventArgs e)
{
objFramework = new FrameworkManagementService();
objFrameworkBO = new FrameworkBO();
objFrameworkBO.FrameworkId = Session["frameworkId"].ToInt32();
objFrameworkBO.FrameworkEngName = txtFrameworkEngName.Text;
objFrameworkBO.FrameworkNepName = txtFrameworkNepName.Text;
objFrameworkBO.BaseYearId = ddlBaseYear.SelectedValue.ToInt32();
objFrameworkBO.FirstYearId = ddlFirstYear.SelectedValue.ToInt32();
objFrameworkBO.SecondYearId = ddlSecondYear.SelectedValue.ToInt32();
objFrameworkBO.ThirdYearId = ddlThirdYear.SelectedValue.ToInt32();
if (Session["frameworkId"].ToInt32() > 0)
{
objFrameworkBO.Mode = "U";
}
else
{
objFrameworkBO.Mode = "I";
}
objFrameworkBO.IsEnable = 1;
objFrameworkBO.IsLocked = 0;
objFramework.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationFramework();
Int32 i = 0;
i = objFramework.AddEditFramework(objFrameworkBO);
if (i > 0)
{
Response.Write("<script>alert('Framework added successfully!')</script>");
Response.Redirect(Constants.ConstantAppPath + "/Modules/FrameworkManagement/AddEditFramework.aspx");
}
else
{
Response.Write("<script>alert('Framework addition failed!')</script>");
}
}
protected void BtnEdit_Command(object sender, CommandEventArgs e)
{
int frameworkId = 0;
if (e.CommandName == "edit")
{
frameworkId = int.Parse(e.CommandArgument.ToString());
SecureQueryString str = new SecureQueryString();
str["frameworkId"] = e.CommandArgument.ToString();
Response.Redirect(Constants.ConstantAppPath + "/Modules/FrameworkManagement/AddEditFramework.aspx" + str.EncryptedString);
}
else if (e.CommandName == "delete")
{
int i = 0;
frameworkId = int.Parse(e.CommandArgument.ToString());
objFrameworkBo = new FrameworkBO();
objFrameworkBo.FrameworkId = frameworkId;
objFrameworkBo.Mode = "D";
wbs = new FrameworkManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationFramework();
i = wbs.AddEditFramework(objFrameworkBo);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/FrameworkManagement/FrameworkList.aspx");
}
else
{
Response.Write("<script>alert('Delete failed')</script>");
}
}
else if (e.CommandName == "lock")
{
int i = 0;
frameworkId = int.Parse(e.CommandArgument.ToString());
objFrameworkBo = new FrameworkBO();
objFrameworkBo.FrameworkId = frameworkId;
objFrameworkBo.Mode = "L";
wbs = new FrameworkManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationFramework();
i = wbs.AddEditFramework(objFrameworkBo);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/FrameworkManagement/FrameworkList.aspx");
}
else
{
Response.Write("<script>alert('Lock failed')</script>");
}
}
else
{
int i = 0;
frameworkId = int.Parse(e.CommandArgument.ToString());
objFrameworkBo = new FrameworkBO();
objFrameworkBo.FrameworkId = frameworkId;
objFrameworkBo.Mode = "L";
wbs = new FrameworkManagementService();
wbs.AuthSoapHdValue = ServiceAuth.ServiceAuthenticationFramework();
i = wbs.AddEditFramework(objFrameworkBo);
if (i > 0)
{
Response.Redirect(Constants.ConstantAppPath + "/Modules/FrameworkManagement/FrameworkList.aspx");
}
else
{
Response.Write("<script>alert('Unlock failed')</script>");
}
}
}
public DataTable PopulateFrameworkDetails(FrameworkBO objFrameworkBO)
{
Authentication();
return(objFramework.PopulateFrameworkDetails(objFrameworkBO));
}
public int AddEditFramework(FrameworkBO objFrameworkBO)
{
Authentication();
return(objFramework.AddEditFramework(objFrameworkBO));
}
