private void SaveData(string IsDelete)
{
long lngID = 0;
try
{
if (hfIsUpdate.Value == "N")
{
lngID = objDB.GerMaxIDNumber("CostCenterList", "CostCenterId");
}
else
{
lngID = Convert.ToInt32(hfID.Value);
}
clsCommonSetup objCommonSetup = new clsCommonSetup(lngID.ToString(), txtCode.Text.Trim(), txtName.Text.Trim(), (chkInActive.Checked == true ? "N" : "Y"), "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", "N");
objSOFMgr.InsertCostCenterList(objCommonSetup, hfIsUpdate.Value, IsDelete);
lblMsg.Text = Common.GetMessage(hfIsUpdate.Value.ToString(), IsDelete);
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
long lngID = 0;
try
{
string EmpID = Session["EMPLOYEEID"].ToString();
string strMonth = Convert.ToString(DateTime.Today.Month);
string strYear = Convert.ToString(DateTime.Today.Year);
clsCommonSetup objCommonSetup = new clsCommonSetup(lngID.ToString(), "", "Y", "N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", "N");
objPayRptMgr.UpdateAttandance(objCommonSetup, this.ddlRemarksType.SelectedItem.Value.ToString(), this.txtRemarks.Text.ToString(),
this.txtFromDate.Text.ToString(), this.txtToDate.Text.ToString(), EmpID);
objTSM.GenerateTimeSheet(EmpID, strMonth, strYear, Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()));
this.UpdateFoxpro();
lblMsg.Text = Common.GetMessage("Y", IsDelete);
Common.EmptyTextBoxValues(this);
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
long lngID = 0;
try
{
MasterTablesManager MasMgr = new MasterTablesManager();
if (hfIsUpdate.Value == "N")
{
lngID = objDB.GerMaxIDNumber("EmpNatureList", "EmpNatureID");
}
else
{
lngID = Convert.ToInt32(hfID.Value);
}
clsCommonSetup objEmpType = new clsCommonSetup(lngID.ToString(), "", txtEmpNature.Text.Trim(), (chkInActive.Checked == true ? "N" : "Y"),
"N", Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", "N");
MasMgr.InsertEmpNature(objEmpType, hfIsUpdate.Value, IsDelete);
lblMsg.Text = Common.GetMessage(hfIsUpdate.Value.ToString(), IsDelete);
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
try
{
if (hfIsUpdate.Value == "Y")
{
hfId.Value = hfId.Value;
}
else
{
hfId.Value = Common.getMaxId("TrainingMode", "TrainingModeID");
}
clsCommonSetup objCommonSetup = new clsCommonSetup(hfId.Value.ToString(), txtName.Text.Trim(), (chkInActive.Checked == true ? "N" : "Y"), "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);
objEmpMgr.InsertTrainingMode(objCommonSetup, hfIsUpdate.Value, IsDelete);
lblMsg.Text = Common.GetMessage(hfIsUpdate.Value.ToString(), IsDelete);
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
// Insert or Update or Delete Data of Learning Activity table
public void InsertLearningActivity(clsCommonSetup clsCommon, string IsUpdate, string IsDelete)
{
SqlCommand command = new SqlCommand("proc_Insert_LearningActivityList");
command.CommandType = CommandType.StoredProcedure;
SqlParameter p_LActivityId = command.Parameters.Add("LActivityId", SqlDbType.BigInt);
p_LActivityId.Direction = ParameterDirection.Input;
p_LActivityId.Value = clsCommon.ID;
SqlParameter p_LActivityName = command.Parameters.Add("LActivityName", SqlDbType.VarChar);
p_LActivityName.Direction = ParameterDirection.Input;
p_LActivityName.Value = clsCommon.Name;
SqlParameter p_IsActive = command.Parameters.Add("IsActive", SqlDbType.Char);
p_IsActive.Direction = ParameterDirection.Input;
p_IsActive.Value = clsCommon.IsActive;
SqlParameter p_isDeleted = command.Parameters.Add("IsDeleted", SqlDbType.Char);
p_isDeleted.Direction = ParameterDirection.Input;
p_isDeleted.Value = clsCommon.IsDeleted;
SqlParameter p_InsertedBy = command.Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate = command.Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate.Direction = ParameterDirection.Input;
p_InsertedDate.Value = clsCommon.InsertedDate;
SqlParameter p_IsUpdate = command.Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate.Direction = ParameterDirection.Input;
p_IsUpdate.Value = IsUpdate;
SqlParameter p_IsDelete = command.Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete.Direction = ParameterDirection.Input;
p_IsDelete.Value = IsDelete;
try
{
objDC.ExecuteQuery(command);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
command = null;
}
}
public void InsertGroup(clsCommonSetup clsCommon, string IsUpdate, string IsDelete)
{
// sproc functionality
SqlCommand command = new SqlCommand("proc_InUp_KPIGroupList");
command.CommandType = CommandType.StoredProcedure;
SqlParameter p_Id = command.Parameters.Add("GroupId", SqlDbType.BigInt);
p_Id.Direction = ParameterDirection.Input;
p_Id.Value = Convert.ToInt32(clsCommon.ID);
SqlParameter p_Name = command.Parameters.Add("GroupName", SqlDbType.VarChar);
p_Name.Direction = ParameterDirection.Input;
p_Name.Value = clsCommon.Name;
SqlParameter p_IsActive = command.Parameters.Add("IsActive", SqlDbType.Char);
p_IsActive.Direction = ParameterDirection.Input;
p_IsActive.Value = clsCommon.IsActive;
SqlParameter p_InsertedBy = command.Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate = command.Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate.Direction = ParameterDirection.Input;
p_InsertedDate.Value = clsCommon.InsertedDate;
SqlParameter p_IsUpdate = command.Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate.Direction = ParameterDirection.Input;
p_IsUpdate.Value = IsUpdate;
SqlParameter p_IsDelete = command.Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete.Direction = ParameterDirection.Input;
p_IsDelete.Value = IsDelete;
try
{
objDC.ExecuteQuery(command);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
command = null;
}
}
public void InsertEmpDocument(clsCommonSetup clsCommon, string sEmpID, string sfileName, string sFilePath, string IsDelete)
{
// sproc functionality
SqlCommand command = new SqlCommand("proc_InUp_EmpDocument");
command.CommandType = CommandType.StoredProcedure;
SqlParameter p_Id = command.Parameters.Add("ID", SqlDbType.BigInt);
p_Id.Direction = ParameterDirection.Input;
p_Id.Value = Convert.ToInt32(clsCommon.ID);
SqlParameter p_Name = command.Parameters.Add("EmpId", SqlDbType.Char);
p_Name.Direction = ParameterDirection.Input;
p_Name.Value = sEmpID;
SqlParameter p_GroupId = command.Parameters.Add("FileName", SqlDbType.VarChar);
p_GroupId.Direction = ParameterDirection.Input;
p_GroupId.Value = sfileName;
SqlParameter p_IndTypeId = command.Parameters.Add("FilePath", SqlDbType.VarChar);
p_IndTypeId.Direction = ParameterDirection.Input;
p_IndTypeId.Value = sFilePath;
SqlParameter p_InsertedBy = command.Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate = command.Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate.Direction = ParameterDirection.Input;
p_InsertedDate.Value = clsCommon.InsertedDate;
SqlParameter p_IsDelete = command.Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete.Direction = ParameterDirection.Input;
p_IsDelete.Value = IsDelete;
try
{
objDC.ExecuteQuery(command);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
command = null;
}
}
private void SaveData(string IsDelete)
{
//if (hfIsUpdate.Value == "N")
// hfID.Value = objDB.GerMaxIDNumber("TrainingService", "TraServiceID").ToString();
//else
// hfID.Value = Convert.ToInt32(hfID.Value).ToString();
try
{
string maxTrnid = "";
clsCommonSetup objTrainSetup = new clsCommonSetup();
if (this.txtTrainingName.Text.Trim() != "")
{
maxTrnid = Common.getMaxId("TrainingList", "TrainingId");
objTrainSetup = new clsCommonSetup(maxTrnid, this.txtTrainingName.Text.Trim(), "Y", "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);
//objTrmMgr.InsertTraining(objTrainSetup, "N", IsDelete);
}
string MaxResourceId = "";
clsCommonSetup objResourceSetup = new clsCommonSetup();
if (this.txtResourcePerson.Text.Trim() != "")
{
MaxResourceId = Common.getMaxId("ResourcePersonList", "ResourcePersonId");
objResourceSetup = new clsCommonSetup(MaxResourceId, this.txtResourcePerson.Text.Trim(), "Y", "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);
//objTrmMgr.InsertResourcePerson(objResourceSetup, "N", IsDelete);
}
objTrmMgr.InsertTrainingService(this.BindObject(maxTrnid, MaxResourceId), objTrainSetup, objResourceSetup, Session["USERID"].ToString(), hfIsUpdate.Value, IsDelete);
lblMsg.Text = Common.GetMessage(hfIsUpdate.Value.ToString(), IsDelete);
//Common.EmptyTextBoxValues(this);
//this.EntryMode(false);
if (ddlTraining.SelectedIndex == 0)
{
Common.FillDropDownList_Nil(objMasMgr.SelectTrainingName(0, "Y"), ddlTraining);
txtTrainingName.Text = "";
}
if (ddlResourcePersonId.SelectedIndex == 0)
{
Common.FillDropDownList_Nil(objMasMgr.SelectResourcePersonList(0, "Y"), ddlResourcePersonId);
txtResourcePerson.Text = "";
}
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
long lngID = 0;
try
{
if (hfIsUpdate.Value == "N")
{
lngID = objDB.GerMaxIDNumber("KPIEmpkpiMst", "EKPIID");
}
else
{
lngID = Convert.ToInt32(hfId.Value);
}
clsCommonSetup objCommonSetup = new clsCommonSetup(lngID.ToString(), "", (chkInActive.Checked == true ? "N" : "Y"), "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);
//objKpi.InsertEmpKpiData(grEmpKpi, ddlMonth.SelectedValue.Trim(), ddlYear.SelectedValue.Trim(),
//Common.ReturnDate(txtIssueDate.Text.Trim()), Session["USERID"].ToString().Trim(), Common.SetDateTime(DateTime.Now.ToString()));
objKpi.InsertEmpKpiData(objCommonSetup,
grEmpKpi,
ddlGroup.SelectedValue.ToString(),
ddlQuarter.SelectedValue.ToString(),
txtYear.Text.ToString(),
txtEmpID.Text.ToString().Trim(),
hfIsUpdate.Value,
IsDelete);
if (hfIsUpdate.Value == "N")
{
lblMsg.Text = "Record Saved Successfully";
}
else
{
lblMsg.Text = "Record Updated Successfully";
}
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string sEmpID, string sfileName, string sFilePath)
{
long lngID = 0;
try
{
lngID = objDB.GerMaxIDNumber("EmpDocInfo", "ID");
clsCommonSetup objCommonSetup = new clsCommonSetup(lngID.ToString(), "", "Y", "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", "N");
utm.InsertEmpDocument(objCommonSetup, sEmpID, sfileName, sFilePath, "N");
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
long lngID = 0;
try
{
MasterTablesManager MasMgr = new MasterTablesManager();
//Filling Class Properties with values
if (hfIsUpadate.Value == "N")
{
lngID = objDB.GerMaxIDNumber("LocationCategory", "LocCatId");
}
else
{
lngID = Convert.ToInt32(hfID.Value);
}
clsCommonSetup objSetup = new clsCommonSetup(lngID.ToString(), txtClinicType.Text.Trim(), (ChkIsActive.Checked == true ? "N" : "Y"), "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", "N");
MasMgr.InsertLocationCategory(objSetup, hfIsUpadate.Value, IsDelete);
if (hfIsUpadate.Value == "N")
{
lblMsg.Text = "Record Saved Successfully";
}
else
{
lblMsg.Text = "Record Updated Successfully";
}
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
long lngID = 0;
try
{
if (hfIsUpdate.Value == "N")
{
lngID = objDB.GerMaxIDNumber("KPIScoring", "ScoringID");
}
else
{
lngID = Convert.ToInt32(hfId.Value);
}
clsCommonSetup objCommonSetup = new clsCommonSetup(lngID.ToString(), txtRating.Text.Trim(), (chkInActive.Checked == true ? "N" : "Y"), "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);
objKpi.InsertScoring(objCommonSetup, ddlGroup.SelectedValue.ToString(), ddlQuarter.SelectedValue.ToString(), NullOrEmpty(txtYear.Text.ToString()),
NullOrEmpty(txtMFrom.Text.ToString().Trim()), NullOrEmpty(txtMTo.Text.ToString().Trim()), txtScore.Text.Trim(), hfIsUpdate.Value, IsDelete);
if (hfIsUpdate.Value == "N")
{
lblMsg.Text = "Record Saved Successfully";
}
else
{
lblMsg.Text = "Record Updated Successfully";
}
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
long lngID = 0;
try
{
if (hfIsUpdate.Value == "N")
{
lngID = objDB.GerMaxIDNumber("KPIIndicatirType", "IndTypeId");
}
else
{
lngID = Convert.ToInt32(hfId.Value);
}
clsCommonSetup objCommonSetup = new clsCommonSetup(lngID.ToString(), txtIndicatirType.Text.Trim(), (chkInActive.Checked == true ? "N" : "Y"), "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);
objKpi.InsertIndicatirType(objCommonSetup, hfIsUpdate.Value, IsDelete);
if (hfIsUpdate.Value == "N")
{
lblMsg.Text = "Record Saved Successfully";
}
else
{
lblMsg.Text = "Record Updated Successfully";
}
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
private void SaveData(string IsDelete)
{
try
{
if (hfIsUpdate.Value == "Y")
{
hfId.Value = hfId.Value;
}
else
{
hfId.Value = Common.getMaxId("SubjectList", "SubjectId");
}
clsCommonSetup objCommonSetup = new clsCommonSetup(hfId.Value.ToString(), txtName.Text.Trim(), (chkInActive.Checked == true ? "N" : "Y"), "N",
Session["USERID"].ToString(), Common.SetDateTime(DateTime.Now.ToString()), "N", IsDelete);
objEmpMgr.InsertSubject(objCommonSetup, hfIsUpdate.Value, IsDelete);
if (hfIsUpdate.Value == "N")
{
lblMsg.Text = "Record Saved Successfully";
}
else
{
lblMsg.Text = "Record Updated Successfully";
}
Common.EmptyTextBoxValues(this);
this.EntryMode(false);
this.OpenRecord();
}
catch (Exception ex)
{
lblMsg.Text = "";
throw (ex);
}
}
public void UpdateAttandance(clsCommonSetup clsCommon, string strRemarkType, string remarks, string strFdate, string strTdate, string empID)
{
int i = 0;
SqlCommand[] command = new SqlCommand[2];
command[i] = new SqlCommand("proc_Update_Attandance");
command[i].CommandType = CommandType.StoredProcedure;
SqlParameter p_RType = command[i].Parameters.Add("RemarksType", SqlDbType.Char);
p_RType.Direction = ParameterDirection.Input;
p_RType.Value = strRemarkType;
SqlParameter p_Remarks = command[i].Parameters.Add("Remarks", SqlDbType.VarChar);
p_Remarks.Direction = ParameterDirection.Input;
p_Remarks.Value = remarks;
SqlParameter p_Fdate = command[i].Parameters.Add("FromDate", SqlDbType.DateTime);
p_Fdate.Direction = ParameterDirection.Input;
p_Fdate.Value = Common.ReturnDate(strFdate);
SqlParameter p_Tdate = command[i].Parameters.Add("ToDate", SqlDbType.DateTime);
p_Tdate.Direction = ParameterDirection.Input;
p_Tdate.Value = Common.ReturnDate(strTdate);
SqlParameter p_InsertedBy = command[i].Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_empID = command[i].Parameters.Add("EmployeeID", SqlDbType.VarChar);
p_empID.Direction = ParameterDirection.Input;
p_empID.Value = empID;
i++;
command[i] = new SqlCommand("proc_Update_Attandance");
command[i].CommandType = CommandType.StoredProcedure;
SqlParameter p_AttRType = command[i].Parameters.Add("RemarksType", SqlDbType.Char);
p_AttRType.Direction = ParameterDirection.Input;
p_AttRType.Value = strRemarkType;
SqlParameter p_AttRemarks = command[i].Parameters.Add("Remarks", SqlDbType.VarChar);
p_AttRemarks.Direction = ParameterDirection.Input;
p_AttRemarks.Value = remarks;
SqlParameter p_AttFdate = command[i].Parameters.Add("FromDate", SqlDbType.DateTime);
p_AttFdate.Direction = ParameterDirection.Input;
p_AttFdate.Value = Common.ReturnDate(strFdate);
SqlParameter p_AttTdate = command[i].Parameters.Add("ToDate", SqlDbType.DateTime);
p_AttTdate.Direction = ParameterDirection.Input;
p_AttTdate.Value = Common.ReturnDate(strTdate);
SqlParameter p_AttInsertedBy = command[i].Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_AttInsertedBy.Direction = ParameterDirection.Input;
p_AttInsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_AttempID = command[i].Parameters.Add("EmployeeID", SqlDbType.VarChar);
p_AttempID.Direction = ParameterDirection.Input;
p_AttempID.Value = empID;
try
{
objDC.MakeTransaction(command);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
command = null;
}
}
// Emp KPI Entry
public void UpdateEmpKpi(clsCommonSetup clsCommon, GridView grv, string strGroup, string strQuertar, string strYear,
string strEmpId, string IsUpdate, string IsDelete)
{
int i = 0;
SqlCommand[] command;
command = new SqlCommand[grv.Rows.Count];
foreach (GridViewRow gRow in grv.Rows)
{
CheckBox chkB = (CheckBox)gRow.Cells[0].FindControl("chkBox");
if (chkB.Checked == true)
{
command[i] = new SqlCommand("Proc_Up_KPIEmpkpi");
command[i].CommandType = CommandType.StoredProcedure;
SqlParameter p_EKPIID = command[i].Parameters.Add("EKPIID", SqlDbType.BigInt);
p_EKPIID.Direction = ParameterDirection.Input;
p_EKPIID.Value = Convert.ToInt32(grv.DataKeys[gRow.DataItemIndex].Values[2].ToString().Trim());
SqlParameter p_EMPID = command[i].Parameters.Add("EmpId", SqlDbType.Char);
p_EMPID.Direction = ParameterDirection.Input;
p_EMPID.Value = strEmpId;
SqlParameter p_SBUId = command[i].Parameters.Add("GroupId", SqlDbType.BigInt);
p_SBUId.Direction = ParameterDirection.Input;
p_SBUId.Value = Convert.ToInt32(strGroup);
SqlParameter p_QuarterId = command[i].Parameters.Add("QuarterId", SqlDbType.BigInt);
p_QuarterId.Direction = ParameterDirection.Input;
p_QuarterId.Value = Convert.ToInt32(strQuertar);
SqlParameter p_VYear = command[i].Parameters.Add("VYear", SqlDbType.BigInt);
p_VYear.Direction = ParameterDirection.Input;
p_VYear.Value = Convert.ToInt32(strYear);
SqlParameter p_KpiId = command[i].Parameters.Add("KpiId", SqlDbType.BigInt);
p_KpiId.Direction = ParameterDirection.Input;
p_KpiId.Value = Convert.ToInt32(grv.DataKeys[gRow.DataItemIndex].Values[1].ToString().Trim());
TextBox txtM = (TextBox)gRow.Cells[6].FindControl("txtAchive");
SqlParameter p_Target = command[i].Parameters.Add("Achive", SqlDbType.BigInt);
p_Target.Direction = ParameterDirection.Input;
p_Target.Value = Convert.ToInt32("0" + txtM.Text);
TextBox txtB = (TextBox)gRow.Cells[7].FindControl("txtAchivePercent");
SqlParameter p_Measur = command[i].Parameters.Add("AchivePercent", SqlDbType.BigInt);
p_Measur.Direction = ParameterDirection.Input;
p_Measur.Value = Convert.ToInt32("0" + txtB.Text);
SqlParameter p_IsActive1 = command[i].Parameters.Add("IsActive", SqlDbType.Char);
p_IsActive1.Direction = ParameterDirection.Input;
p_IsActive1.Value = clsCommon.IsActive;
SqlParameter p_InsertedBy1 = command[i].Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy1.Direction = ParameterDirection.Input;
p_InsertedBy1.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate1 = command[i].Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate1.Direction = ParameterDirection.Input;
p_InsertedDate1.Value = clsCommon.InsertedDate;
SqlParameter p_IsUpdate1 = command[i].Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate1.Direction = ParameterDirection.Input;
p_IsUpdate1.Value = IsUpdate;
SqlParameter p_IsDelete1 = command[i].Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete1.Direction = ParameterDirection.Input;
p_IsDelete1.Value = IsDelete;
i++;
}
}
objDC.MakeTransaction(command);
}
// Emp KPI Entry
public void InsertEmpKpiData(clsCommonSetup clsCommon, GridView grv, string strGroup, string strQuertar, string strYear, string strEmpId, string IsUpdate, string IsDelete)
{
int i = 0;
SqlCommand[] command;
command = new SqlCommand[grv.Rows.Count + 1];
//DELETE FROM DETAILS TABLE
command[0] = new SqlCommand("proc_InUp_KPIEmpkpiMst");
command[0].CommandType = CommandType.StoredProcedure;
SqlParameter p_UserId = command[0].Parameters.Add("EKPIID", SqlDbType.BigInt);
p_UserId.Direction = ParameterDirection.Input;
p_UserId.Value = Convert.ToInt32(clsCommon.ID);
SqlParameter p_DivisionId = command[0].Parameters.Add("EmpId", SqlDbType.Char);
p_DivisionId.Direction = ParameterDirection.Input;
p_DivisionId.Value = strEmpId;
SqlParameter p_SBUId = command[0].Parameters.Add("GroupId", SqlDbType.BigInt);
p_SBUId.Direction = ParameterDirection.Input;
p_SBUId.Value = Convert.ToInt32(strGroup);
SqlParameter p_QuarterId = command[0].Parameters.Add("QuarterId", SqlDbType.BigInt);
p_QuarterId.Direction = ParameterDirection.Input;
p_QuarterId.Value = Convert.ToInt32(strQuertar);
SqlParameter p_VYear = command[0].Parameters.Add("VYear", SqlDbType.BigInt);
p_VYear.Direction = ParameterDirection.Input;
p_VYear.Value = Convert.ToInt32(strYear);
SqlParameter p_IsActive = command[0].Parameters.Add("IsActive", SqlDbType.Char);
p_IsActive.Direction = ParameterDirection.Input;
p_IsActive.Value = clsCommon.IsActive;
SqlParameter p_InsertedBy = command[0].Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate = command[0].Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate.Direction = ParameterDirection.Input;
p_InsertedDate.Value = clsCommon.InsertedDate;
SqlParameter p_IsUpdate = command[0].Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate.Direction = ParameterDirection.Input;
p_IsUpdate.Value = IsUpdate;
SqlParameter p_IsDelete = command[0].Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete.Direction = ParameterDirection.Input;
p_IsDelete.Value = IsDelete;
i = 1;
// long lngTransID = Convert.ToInt64(Common.getMaxId("KPIEmpkpiDetail", "KPIDtlId"));
foreach (GridViewRow gRow in grv.Rows)
{
CheckBox chkB = (CheckBox)gRow.Cells[0].FindControl("chkBox");
if (chkB.Checked == true)
{
command[i] = new SqlCommand("Proc_InUp_KPIEmpkpiDetail");
command[i].CommandType = CommandType.StoredProcedure;
SqlParameter p_EKPIID = command[i].Parameters.Add("EKPIID", SqlDbType.BigInt);
p_EKPIID.Direction = ParameterDirection.Input;
p_EKPIID.Value = Convert.ToInt32(clsCommon.ID);
SqlParameter p_EMPID = command[i].Parameters.Add("EmpId", SqlDbType.Char);
p_EMPID.Direction = ParameterDirection.Input;
p_EMPID.Value = strEmpId;
SqlParameter p_KpiId = command[i].Parameters.Add("KpiId", SqlDbType.BigInt);
p_KpiId.Direction = ParameterDirection.Input;
p_KpiId.Value = Convert.ToInt32(grv.DataKeys[gRow.DataItemIndex].Values[1].ToString().Trim());
// Convert.ToInt32(gRow.Cells[2].Text.Trim()); //gRow.Cells[2].Text.Trim()
//grScoring.DataKeys[_gridView.SelectedIndex].Values[0].ToString();
TextBox txtB = (TextBox)gRow.Cells[4].FindControl("txtMeasur");
SqlParameter p_Measur = command[i].Parameters.Add("Measur", SqlDbType.VarChar);
p_Measur.Direction = ParameterDirection.Input;
p_Measur.Value = txtB.Text; //gRow.Cells[4].Text.Trim();
// grv.SelectedRow.Cells[3].Text
TextBox txtM = (TextBox)gRow.Cells[5].FindControl("txtTarget");
SqlParameter p_Target = command[i].Parameters.Add("Target", SqlDbType.VarChar);
p_Target.Direction = ParameterDirection.Input;
p_Target.Value = txtM.Text; //gRow.Cells[5].Text.Trim();
SqlParameter p_IsActive1 = command[i].Parameters.Add("IsActive", SqlDbType.Char);
p_IsActive1.Direction = ParameterDirection.Input;
p_IsActive1.Value = clsCommon.IsActive;
SqlParameter p_InsertedBy1 = command[i].Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy1.Direction = ParameterDirection.Input;
p_InsertedBy1.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate1 = command[i].Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate1.Direction = ParameterDirection.Input;
p_InsertedDate1.Value = clsCommon.InsertedDate;
SqlParameter p_IsUpdate1 = command[i].Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate1.Direction = ParameterDirection.Input;
p_IsUpdate1.Value = IsUpdate;
SqlParameter p_IsDelete1 = command[i].Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete1.Direction = ParameterDirection.Input;
p_IsDelete1.Value = IsDelete;
i++;
}
}
objDC.MakeTransaction(command);
}
public void InsertScoring(clsCommonSetup clsCommon, string strGroupID, string strQuarterID, string txtYear, string txtMFrom, string txtMTo, string strScore, string IsUpdate, string IsDelete)
{
// sproc functionality
SqlCommand command = new SqlCommand("proc_InUp_KPIScoring");
command.CommandType = CommandType.StoredProcedure;
SqlParameter p_Id = command.Parameters.Add("ScoringID", SqlDbType.BigInt);
p_Id.Direction = ParameterDirection.Input;
p_Id.Value = Convert.ToInt32(clsCommon.ID);
SqlParameter p_Name = command.Parameters.Add("Rating", SqlDbType.VarChar);
p_Name.Direction = ParameterDirection.Input;
p_Name.Value = clsCommon.Name;
SqlParameter p_GroupId = command.Parameters.Add("GroupId", SqlDbType.BigInt);
p_GroupId.Direction = ParameterDirection.Input;
p_GroupId.Value = Convert.ToInt32(strGroupID);
SqlParameter p_IndTypeId = command.Parameters.Add("QuarterId", SqlDbType.BigInt);
p_IndTypeId.Direction = ParameterDirection.Input;
p_IndTypeId.Value = Convert.ToInt32(strQuarterID);
SqlParameter p_VYear = command.Parameters.Add("VYear", SqlDbType.BigInt);
p_VYear.Direction = ParameterDirection.Input;
p_VYear.Value = Convert.ToInt32(txtYear);
SqlParameter p_MarksF = command.Parameters.Add("MarksF", SqlDbType.BigInt);
p_MarksF.Direction = ParameterDirection.Input;
p_MarksF.Value = Convert.ToInt32(txtMFrom);
SqlParameter p_MarksTo = command.Parameters.Add("MarksTo", SqlDbType.BigInt);
p_MarksTo.Direction = ParameterDirection.Input;
p_MarksTo.Value = Convert.ToInt32(txtMTo);
SqlParameter p_txtScore = command.Parameters.Add("Score", SqlDbType.BigInt);
p_txtScore.Direction = ParameterDirection.Input;
p_txtScore.Value = Convert.ToInt32(strScore);
SqlParameter p_IsActive = command.Parameters.Add("IsActive", SqlDbType.Char);
p_IsActive.Direction = ParameterDirection.Input;
p_IsActive.Value = clsCommon.IsActive;
SqlParameter p_InsertedBy = command.Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate = command.Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate.Direction = ParameterDirection.Input;
p_InsertedDate.Value = clsCommon.InsertedDate;
SqlParameter p_IsUpdate = command.Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate.Direction = ParameterDirection.Input;
p_IsUpdate.Value = IsUpdate;
SqlParameter p_IsDelete = command.Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete.Direction = ParameterDirection.Input;
p_IsDelete.Value = IsDelete;
try
{
objDC.ExecuteQuery(command);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
command = null;
}
}
// Insert or Update or Delete Data of Appraisal Rating table
public void InsertAppraisalRating(clsCommonSetup clsCommon, string strRatingMin, string strRatingMax, string strBasicPercent, string IsUpdate, string IsDelete)
{
SqlCommand command = new SqlCommand("proc_Insert_AppraisalRatingList");
command.CommandType = CommandType.StoredProcedure;
SqlParameter p_Id = command.Parameters.Add("RatingId", SqlDbType.BigInt);
p_Id.Direction = ParameterDirection.Input;
p_Id.Value = clsCommon.ID;
SqlParameter p_Name = command.Parameters.Add("RatingName", SqlDbType.VarChar);
p_Name.Direction = ParameterDirection.Input;
p_Name.Value = clsCommon.Name;
SqlParameter p_RatingMin = command.Parameters.Add("RatingMin", SqlDbType.BigInt);
p_RatingMin.Direction = ParameterDirection.Input;
p_RatingMin.Value = strRatingMin;
SqlParameter p_RatingMax = command.Parameters.Add("RatingMax", SqlDbType.BigInt);
p_RatingMax.Direction = ParameterDirection.Input;
p_RatingMax.Value = strRatingMax;
SqlParameter p_BasicPercent = command.Parameters.Add("BasicPercent", SqlDbType.Decimal);
p_BasicPercent.Direction = ParameterDirection.Input;
p_BasicPercent.Value = strBasicPercent;
SqlParameter p_IsActive = command.Parameters.Add("IsActive", SqlDbType.Char);
p_IsActive.Direction = ParameterDirection.Input;
p_IsActive.Value = clsCommon.IsActive;
SqlParameter p_isDeleted = command.Parameters.Add("IsDeleted", SqlDbType.Char);
p_isDeleted.Direction = ParameterDirection.Input;
p_isDeleted.Value = clsCommon.IsDeleted;
SqlParameter p_InsertedBy = command.Parameters.Add("InsertedBy", SqlDbType.VarChar);
p_InsertedBy.Direction = ParameterDirection.Input;
p_InsertedBy.Value = clsCommon.InsertedBy;
SqlParameter p_InsertedDate = command.Parameters.Add("InsertedDate", SqlDbType.DateTime);
p_InsertedDate.Direction = ParameterDirection.Input;
p_InsertedDate.Value = clsCommon.InsertedDate;
SqlParameter p_IsUpdate = command.Parameters.Add("IsUpdate", SqlDbType.Char);
p_IsUpdate.Direction = ParameterDirection.Input;
p_IsUpdate.Value = IsUpdate;
SqlParameter p_IsDelete = command.Parameters.Add("IsDelete", SqlDbType.Char);
p_IsDelete.Direction = ParameterDirection.Input;
p_IsDelete.Value = IsDelete;
try
{
objDC.ExecuteQuery(command);
}
catch (Exception ex)
{
throw (ex);
}
finally
{
command = null;
}
}
