private void activateUser()
{
string userID = panActivate_drpUsers.SelectedValue;
string sql;
if (userID == "0")
{
return;
}
if (userID == common.strAdminName)
{
panActivate_lblActive.Text = "Error: Cannot deactive admin.";
return;
}
sql = string.Format("update onlinebill.users set active = decode(active,0,1,0) where userid='{0}'", userID);
try
{
OraDBConnection.ExecQry(sql);
panActivate_lblActive.Text = "User activation status changed successfully";
}
catch (Exception ex)
{
panActivate_lblActive.Text = "Error: " + ex.Message;
}
}
private bool ResetRownos(long empid)
{
string sql;
bool res;
sql = @"BEGIN
DELETE FROM cadre.temp_setrowno WHERE empid = " + empid + @";
INSERT INTO cadre.temp_setrowno
SELECT empid,
rowno,
rownum
FROM
(SELECT rowno,empid FROM emphistory WHERE empid = " + empid + @" ORDER BY rowno
);
UPDATE emphistory eh
SET eh.rowno =
(SELECT tsr.newrowno
FROM CADRE.temp_setrowno tsr
WHERE tsr.empid = eh.empid
AND tsr.oldrowno = eh.rowno
)
WHERE eh.empid=" + empid + @";
END;";
res = OraDBConnection.ExecQry(sql);
return(true);
}
protected void btnCreate_Click(object sender, EventArgs e)
{
if (txtpropname.Text == "")
{
Utils.ShowMessageBox(this, "Enter Proposal Name");
return;
}
//status: U-Unsaved, S-Saved
//type: TP-Transfer/Promotion, RD-Redesignation
string sql = "insert into cadre.proposals(pno,pname,pdate,status,type) values" +
"((select nvl(max(pno),0)+1 from cadre.proposals)," +
"'" + txtpropname.Text + "',sysdate,'U','" + PropType.Value + "')";
bool ret = false;
try
{
ret = OraDBConnection.ExecQry(sql);
if (ret == false)
{
throw new Exception("Error in Creating Proposal");
}
}
catch (Exception ex)
{
Utils.ShowMessageBox(this, ex.Message);
return;
}
panNewProp.Visible = false;
txtpropname.Text = "";
FillGrid();
}
private void InsertIntoCadrMap(string empid, string rowno)
{
string sql;
sql = string.Format("INSERT INTO cadre.cadrmap(empid,rowno) VALUES('{0}','{1}')", empid, rowno);
OraDBConnection.ExecQry(sql);
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string desg = drpDesg.SelectedValue;
string startdt = dt_start.Text;
string enddt = dt_end.Text;
string sql = String.Empty;
//reset fromdate,todate and olddesg
sql = "update cadre.rd_proposals set fromdate = null, todate = null, olddesg=null";
OraDBConnection.ExecQry(sql);
//delete earlier entered records (if any) for this proposal
sql = "delete from cadre.prop_redesig where propno = " + propno;
OraDBConnection.ExecQry(sql);
//insert matched records in prop_redesig
sql = String.Format("insert into CADRE.prop_redesig SELECT e.empid, e.firstname || ' ' || e.middlename || ' ' || e.lastname AS name, " +
"to_char(e.dob,'dd-Mon-YYYY') as DOB, m.locabb, to_char(h.fromdate,'dd-Mon-YYYY') AS Promoted_On, {3}, {0} FROM " +
"(SELECT empid, MIN(fromdate) AS fromdate FROM emphistory WHERE desgcode = {0} GROUP BY empid) h, empperso e, mast_loc m " +
"WHERE e.cdesgcode = {0} AND e.recstatus = 10 AND h.empid = e.empid AND m.loccode = e.cloccode " +
"AND h.fromdate BETWEEN to_date('{1}','dd/mm/yyyy') AND to_date('{2}','dd/mm/yyyy')", desg, startdt, enddt, propno);
OraDBConnection.ExecQry(sql);
//enter fromdate, todate and old desg in rd_proposals
sql = string.Format("update cadre.rd_proposals set fromdate = to_date('{0}','dd/mm/yyyy')," +
"todate = to_date('{1}','dd/mm/yyyy'), olddesg={2} where pno={3}",
startdt, enddt, desg, propno);
OraDBConnection.ExecQry(sql);
FillGrid();
Search_Visible(false);
Controls_Vis(gv_redesig.Rows.Count > 0);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (txtoonum.Text.Length < 1)
{
Utils.ShowMessageBox(this, "Enter O/o Number");
return;
}
DateTime checkdate;
if (DateTime.TryParse(txtoodate.Text, out checkdate) == false)
{
Utils.ShowMessageBox(this, "Enter a valid date");
return;
}
//mark proposal as saved
string sql = string.Format("update cadre.ret_proposals set status='S',oonum='{0}',oodate='{1}' where pno={2}",
txtoonum.Text, txtoodate.Text, propno);
if (OraDBConnection.ExecQry(sql) == false)
{
Utils.ShowMessageBox(this, "Error marking proposal as saved");
return;
}
MakeReport(true);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string empid = txtEmpID.Text;
string desg = drpDesg.SelectedValue;
string sql = String.Empty;
string res;
panEmpHist.Visible = false;
//show error if empid doesn't exist or desg doesn't match or recstatus != 10
sql = string.Format("select count(*) from pshr.empperso where empid = '{0}' and cdesgcode = {1} and recstatus=10", empid, desg);
res = OraDBConnection.GetScalar(sql);
if (empid == "" || res != "1")
{
lblDesgMsg.Text = "Invalid EmpID";
return;
}
sql = string.Format("select count(*) from cadre.prop_redesig where empid = {0} and propno = {1}", empid, propno);
if (OraDBConnection.GetScalar(sql) != "0")
{
lblDesgMsg.Text = "EmpID Already Added";
return;
}
sql = String.Format("insert into CADRE.prop_redesig SELECT e.empid, e.firstname || ' ' || e.middlename || ' ' || e.lastname AS name, " +
"to_char(e.dob,'dd-Mon-YYYY') as DOB, m.locabb, to_char(h.fromdate,'dd-Mon-YYYY') AS Promoted_On, {1}, {0} FROM " +
"(SELECT empid, MIN(fromdate) AS fromdate FROM emphistory WHERE desgcode = {0} GROUP BY empid) h, empperso e, mast_loc m " +
"WHERE e.cdesgcode = {0} AND h.empid = e.empid AND m.loccode = e.cloccode and e.empid={2}", desg, propno, empid);
OraDBConnection.ExecQry(sql);
lblDesgMsg.Text = "EmpID Added";
FillGrid();
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string sql;
string role = Session["role"].ToString();
//string date = drpMonth.SelectedValue;
string date = "";
sql = "BEGIN ";
//delete earlier entered records (if any) for this proposal
sql += " delete from cadre.ret_list where propno = " + propno + "; ";
sql += "INSERT INTO cadre.ret_list " +
"SELECT e.empid,last_day (add_months(e.dob - 1, md.retdage * 12)) as DOR, " + propno + ", cdesgcode,null " +
"FROM pshr.empperso e, pshr.mast_desg md " +
"WHERE last_day (add_months(e.dob - 1, md.retdage * 12)) = '" + date + "'" +
"AND e.cdesgcode = md.desgcode " +
"AND e.recstatus = 10" +
"AND e.cdesgcode in (SELECT desgcode from cadre.person_auth_desgs where role = '" + role + "'); ";
sql += string.Format(" update cadre.ret_proposals set retdate = '{0}' where pno={1}; ", date, propno);
sql += " END;";
OraDBConnection.ExecQry(sql);
Controls_Vis(true);
FillGrid();
}
private void SaveCC(bool template, bool saveas = false)
{
string name = saveas?txtSaveAsName.Text:CC_name.Text;
string tags = CC_tags.Text.Replace("'", "''");
string data = CC_data.Text.Replace("'", "''");
string sql;
string type = template ? "T" : "N";
if (!saveas && hidSource.Text == "T")
{
lblmsg.Text = "Cannot change template.";
return;
}
sql = string.Format("merge into cadre.bigcc B using " +
"(select '{0}' as n, '{1}' as t, '{2}' as d , 'N' as ty from dual) D " +
"on (B.name = D.n and B.type='N') " +
"when matched then update set B.tags = D.t, B.data = D.d " +
"when not matched then insert (name, tags, data, type, addedon) values (D.n, D.t, D.d, D.ty, sysdate)"
, name, tags, data);
try
{
OraDBConnection.ExecQry(sql);
lblmsg.Text = template?"Template Saved":"CC Saved";
}
catch (Exception ex)
{
lblmsg.Text = ex.Message;
}
DisableDataFields(true);
}
protected void btnAddLoc_Click(object sender, EventArgs e)
{
string sql;
if (btnAddnote.Text == "Add Note")
{
if (txtNewnote.Text.Length > 0)
{
sql = "insert into cadre.notes_person(sno,notes,ccnum) values(" + GetSNo() + ",'" + txtNewnote.Text + "',-1)";
OraDBConnection.ExecQry(sql);
}
txtNewnote.Text = "";
}
if (btnAddnote.Text == "Update Note")
{
if (txtNewnote.Text.Length > 0)
{
sql = "update cadre.notes_person set notes = '" + txtNewnote.Text + "' where sno = " + lbllstsno.Text;
OraDBConnection.ExecQry(sql);
}
txtNewnote.Text = "";
lbllstsno.Text = "";
btnAddnote.Text = "Add Note";
}
FillListAll();
}
protected void btnDel_Click(object sender, EventArgs e)
{
string aloc;
if (drpLocs.SelectedValue == "")
{
Utils.ShowMessageBox(this, "No Location To Delete");
return;
}
aloc = OraDBConnection.GetScalar("select aloc from pshr.mast_loc where loccode = " + drpLocs.SelectedValue);
if (aloc != "2")
{
Utils.ShowMessageBox(this, "Not Permitted");
}
else if (aloc == "2")
{
if (OraDBConnection.ExecQry("delete from pshr.mast_loc where loccode = " + drpLocs.SelectedValue))
{
Utils.ShowMessageBox(this, "Location Deleted");
}
else
{
Utils.ShowMessageBox(this, "Error Deleting Location");
}
}
FillLocations(drploctype.SelectedValue, chkShowAll.Checked, txtFilter.Text);
}
private void resetPass()
{
string userID = panReset_drpUsers.SelectedValue;
string pass1 = panReset_txtPass1.Value;
string pass2 = panReset_txtPass2.Value;
string sql = string.Empty;
if (userID == "0")
{
return;
}
if (pass1 != pass2)
{
panReset_lblMsg.Text = "Error: Passwords does not match.";
return;
}
if (pass1.Length < 3 || pass1.Length > 64)
{
panReset_lblMsg.Text = "Error: Password length must be between 3 and 64.";
return;
}
sql = string.Format("update onlinebill.users set pass='******' where userid='{1}'", pass1, userID);
try
{
OraDBConnection.ExecQry(sql);
panReset_lblMsg.Text = "Password changed successfully.";
}
catch (Exception ex)
{
panReset_lblMsg.Text = "Error: " + ex.Message;
return;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
string name = CC_name.Text;
string sql = string.Format("delete from cadre.bigcc where name = '{0}'", name);
OraDBConnection.ExecQry(sql);
lblmsg.Text = "CC Deleted";
}
private void VacantCadrMap(long empid, int eventcode)
{
if (eventcode >= 11 && eventcode <= 16)
{
string sql = "delete from cadre.cadrmap where empid=" + empid.ToString();
OraDBConnection.ExecQry(sql);
}
}
private void addUser()
{
string userName = panAdd_txtUsername.Value;
string pass1 = panAdd_txtPass1.Value;
string pass2 = panAdd_txtPass2.Value;
string offcName = panAdd_txtOffcName.Value;
string mobileNo = panAdd_txtMobile.Value;
string issuedTo = panAdd_txtIssuedTo.Value;
const string officeType = "SubDivision";
string sql = string.Empty;
if (string.IsNullOrWhiteSpace(userName) ||
string.IsNullOrWhiteSpace(pass1) ||
string.IsNullOrWhiteSpace(pass2) ||
string.IsNullOrWhiteSpace(offcName) ||
string.IsNullOrWhiteSpace(mobileNo) ||
string.IsNullOrWhiteSpace(issuedTo))
{
panAdd_lblMsg.Text = "Error: All the fields are necessary.";
return;
}
if (pass1 != pass2)
{
panAdd_lblMsg.Text = "Error: Passwords does not match.";
return;
}
if (userName.Length < 3 || userName.Length > 64)
{
panAdd_lblMsg.Text = "Error: Username length must be between 3 and 64.";
return;
}
if (pass1.Length < 3 || pass1.Length > 64)
{
panAdd_lblMsg.Text = "Error: Password length must be between 3 and 64.";
return;
}
sql = string.Format("insert into onlinebill.users(userid, pass, offcname, officetype, mobileno, issuedto, dated, active)" +
"values('{0}','{1}','{2}','{3}','{4}','{5}',sysdate,1)", userName.ToUpper(), pass1, offcName, officeType, mobileNo, issuedTo);
try
{
OraDBConnection.ExecQry(sql);
panAdd_lblMsg.Text = "User added successfully.";
return;
}
catch (Exception ex)
{
if (ex.Message.Contains("ORA-00001"))
{
panAdd_lblMsg.Text = "Error: User already exists.";
return;
}
else
{
panAdd_lblMsg.Text = "Error: " + ex.Message;
}
return;
}
}
protected void gv_redesig_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string empid = gv_redesig.Rows[e.RowIndex].Cells[1].Text.ToString();
string sql = string.Empty;
sql = "delete from cadre.prop_redesig where empid=" + empid + " and propno=" + propno;
OraDBConnection.ExecQry(sql);
FillGrid();
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
string empid = gv_redesig.Rows[((GridViewRow)((LinkButton)sender).Parent.Parent).RowIndex].Cells[2].Text.ToString();
string sql = string.Empty;
sql = "delete from cadre.ret_list where empid=" + empid + " and propno=" + propno;
OraDBConnection.ExecQry(sql);
FillGrid();
}
protected void btnRemLoc_Click(object sender, EventArgs e)
{
string sql;
if (lstAll.SelectedValue != "")
{
sql = "delete from cadre.notes_person where sno=" + lstAll.SelectedValue;
OraDBConnection.ExecQry(sql);
FillListAll();
}
}
private static bool Generate_Grades(int cad_cd)
{
string sql;
DataSet ds_sel;
sql = "DELETE FROM cadre.empgrdno";
OraDBConnection.ExecQry(sql);
sql = "SELECT s.empid, s.senno, s.sendate, d.cadrecode, d.hecode, e.revcategory, e.branchcode " +
"FROM pshr.empsen s, pshr.mast_desg d, pshr.empperso e, pshr.mast_cadre x " +
"WHERE s.empid=e.empid AND e.cdesgcode = d.desgcode AND s.senno BETWEEN '1' AND '999999' AND " +
"d.cadrecode = (SELECT u.cadregrp FROM mast_cadre u WHERE u.cadrecode = " + cad_cd + ") " +
"AND d.cadrecode = x.cadrecode " +
"AND e.branchcode = (SELECT j.branchcode FROM mast_cadre j WHERE j.cadrecode = " + cad_cd + ") " +
"AND e.recstatus = 10 ORDER BY senno";
ds_sel = OraDBConnection.GetData(sql);
if (ds_sel.Tables[0].Rows.Count == 0)
{
return(false);
}
int senno = 0;
foreach (DataRow drow in ds_sel.Tables[0].Rows)
{
senno++;
sql = string.Format("INSERT INTO cadre.empgrdno VALUES({0}, '0', {1}, {2}, {3}, {4}, {5})",
drow["empID"], (drow["hecode"] == System.DBNull.Value) ? 99 : drow["hecode"], drow["cadrecode"], senno, drow["revcategory"], drow["branchcode"]);
OraDBConnection.ExecQry(sql);
}
senno = 0;
sql = " SELECT * FROM cadre.empgrdno ORDER BY hecode, senno";
ds_sel = OraDBConnection.GetData(sql);
int grp_cd = 9999;
foreach (DataRow drow in ds_sel.Tables[0].Rows)
{
if (int.Parse(drow["hecode"].ToString()) != grp_cd)
{
senno = 1;
grp_cd = int.Parse(drow["hecode"].ToString());
}
else
{
senno++;
}
sql = "UPDATE cadre.empgrdno SET grdno = " + senno + " WHERE empid = " + drow["empid"];
OraDBConnection.ExecQry(sql);
}
return(true);
}
private void UpdateEmpperso(string empid, int eventid, string cloccode, string cdesgcode)
{
string sql;
string recstatus = "10";
if (eventid == (int)EVENTS.RETD.RSUP)
{
recstatus = "20";
}
sql = string.Format("UPDATE EMPPERSO SET cloccode = '{0}', cdesgcode = '{1}', recstatus = '{2}' WHERE empid = '{3}'", cloccode, cdesgcode, recstatus, empid);
OraDBConnection.ExecQry(sql);
}
protected void lnkDelete_Click(object sender, EventArgs e)
{
string prono = gvProposals.Rows[((GridViewRow)((LinkButton)sender).Parent.Parent).RowIndex].Cells[2].Text.ToString();
string sql = string.Empty;
sql = "delete from cadre.prop_redesig where propno =" + prono;
OraDBConnection.ExecQry(sql);
sql = "delete from cadre.rd_proposals where pno =" + prono;
OraDBConnection.ExecQry(sql);
FillGrid();
}
protected void btnRemCR_Click(object sender, EventArgs e)
{
string sql = string.Format("insert into cadre.DELETED_CHARGEREPORTS " +
"select * from cadre.chargereport where empid in ({0}) and oonum = '{1}'",
txtEmpIDRemCR.Text, txtOonumRemCR.Text);
OraDBConnection.ExecQry(sql);
sql = string.Format("delete from cadre.chargereport where empid in ({0}) and oonum = '{1}'",
txtEmpIDRemCR.Text, txtOonumRemCR.Text);
OraDBConnection.ExecQry(sql);
Utils.ShowMessageBox(this, "Deleted from Charge Reports");
}
private string DoDelete()
{
long empid = Convert.ToInt64(txtEmpID.Text.Trim());
int rno = Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text.Trim());
string sql = string.Format("DELETE FROM emphistory WHERE empid={0} AND rowno={1}", empid, rno);
bool retval = OraDBConnection.ExecQry(sql);
ResetRownos(empid);
lblmsg.Text = retval ? "Event Deleted Successfully" : "Unable to delete event";
return(rno.ToString());
}
protected void btnArchive_Click(object sender, EventArgs e)
{
string acno = lblAcNo.Text;
string tbl = lblCat.Text;
string userid = Session[common.strUserID].ToString();
string sql = string.Empty;
string sqlCond = string.Empty;
string sqlDel = string.Empty;
string sqlIns = string.Empty;
string sqlLog = string.Empty;
string year = DateTime.Now.Year.ToString();
DataSet ds;
Dictionary <string, string> dict_acno = new Dictionary <string, string>()
{
{ "DSBELOW10KW", "ACCOUNTNO" },
{ "DSABOVE10KW", "ACCOUNTNO" },
{ "LS", "ACCOUNTNO" },
{ "MS", "PRT_AC_NO" },
{ "SP", "ACNO" }
};
if (!dict_acno.ContainsKey(tbl))
{
lblMsg.Text = "Invalid Category";
return;
}
sqlCond = string.Format(" upper({0}) = upper('{1}') and upper(userid) = upper('{2}') ", dict_acno[tbl], acno, userid);
sql = string.Format("select count(*) from {0} where {1}", tbl, sqlCond);
ds = OraDBConnection.GetData(sql);
if (ds.Tables[0].Rows[0][0].ToString() != "1")
{
lblMsg.Text = "No current bill or not uploaded by this user";
return;
}
sqlIns = string.Format("insert into ARCBILL.ARC_{0}_{1} select * from {1} where {2}", year, tbl, sqlCond);
sqlDel = string.Format("delete from {0} where {1}", tbl, sqlCond);
sqlLog = string.Format("insert into ARCHIVEBILL_LOG values ('{0}','{1}', sysdate)", acno, userid);
sql = string.Format("BEGIN {0}; {1}; {2}; END;", sqlIns, sqlDel, sqlLog);
try
{
OraDBConnection.ExecQry(sql);
lblMsg.Text = "Record Archived";
}
catch (Exception ex)
{
lblMsg.Text = ex.Message;
}
}
private void DoLoginAudit(string userID, string userPass, bool isValid, string ip)
{
string sql;
sql = string.Format("insert into onlinebill.loginaudit values('{0}','{1}',{2},'{3}',sysdate)",
userID, userPass, isValid ? 1 : 0, ip);
try
{
OraDBConnection.ExecQry(sql);
}
catch
{
Response.Redirect(Request.RawUrl);
}
}
protected void btnSearch_Click(object sender, EventArgs e)
{
string desg = drpDesg.SelectedValue;
string startdt = dt_start.Text;
string enddt = dt_end.Text;
string sql = String.Empty;
//reset fromdate,todat
sql = "update cadre.ret_proposals set fromdate = null, todate = null where pno = " + propno;
OraDBConnection.ExecQry(sql);
//delete earlier entered records (if any) for this proposal
sql = "delete from cadre.ret_list where propno = " + propno;
OraDBConnection.ExecQry(sql);
//insert matched records in prop_redesig
//sql = String.Format("insert into CADRE.prop_redesig SELECT e.empid, e.firstname || ' ' || e.middlename || ' ' || e.lastname AS name, "+
// "to_char(e.dob,'dd-Mon-YYYY') as DOB, m.locabb, to_char(h.fromdate,'dd-Mon-YYYY') AS Promoted_On, {3}, {0} FROM " +
// "(SELECT empid, MIN(fromdate) AS fromdate FROM emphistory WHERE desgcode = {0} GROUP BY empid) h, empperso e, mast_loc m "+
// "WHERE e.cdesgcode = {0} AND e.recstatus = 10 AND h.empid = e.empid AND m.loccode = e.cloccode AND h.fromdate BETWEEN '{1}' AND '{2}'", desg, startdt, enddt,propno);
//sql = "SELECT e.empid, firstname||' '|| decode(middlename, NULL, '', middlename||' ') || lastname AS name,"+
// "e.dob AS DOB, md.desgtext, ml.locname,"+
// "last_day (add_months(e.dob - 1, md.retdage * 12)) as DOR"+
// "FROM pshr.empperso e, pshr.mast_loc ml, pshr.mast_desg md"+
// "WHERE last_day (add_months(e.dob - 1, md.retdage * 12)) between '01-Jul-2013' AND '01-Sep-2013'"+
// "AND e.empid like '1%'"+
// "AND e.cloccode = ml.loccode"+
// "AND e.cdesgcode = md.desgcode"+
// "AND e.recstatus = 10" +
// "order by md.hecode,e.empid"
sql = "INSERT INTO cadre.ret_list " +
"SELECT e.empid,last_day (add_months(e.dob - 1, md.retdage * 12)) as DOR, " + propno + ", cdesgcode,null " +
"FROM pshr.empperso e, pshr.mast_desg md " +
"WHERE last_day (add_months(e.dob - 1, md.retdage * 12)) between '" + startdt + "' AND '" + enddt + "' " +
"AND e.empid like '1%' " +
"AND e.cdesgcode = md.desgcode " +
"AND e.recstatus = 10";
OraDBConnection.ExecQry(sql);
//enter fromdate, todate in ret_proposals
sql = string.Format("update cadre.ret_proposals set fromdate = '{0}', todate = '{1}' where pno={2}", startdt, enddt, propno);
OraDBConnection.ExecQry(sql);
FillGrid();
Search_Visible(false);
Controls_Vis(gv_redesig.Rows.Count > 0);
}
protected void btnDone_Click(object sender, EventArgs e)
{
string sql;
int i;
int ccnum = 0;
OraDBConnection.ExecQry("delete from cadre.notes_proposal_person where proposalno = " + prono);
for (i = 0; i < lstCC.Items.Count; i++)
{
ccnum = i + 1;
sql = string.Format("Insert into cadre.notes_proposal_person(sno,ccnum, notes, proposalno) values ({0},{1},'{2}',{3})", ccnum, lstCC.Items[i].Value, lstCC.Items[i].Text, prono);
//sql = "update cadre.cnotes_person set ccnum=" + ccnum + " where sno=" + lstCC.Items[i].Value;
OraDBConnection.ExecQry(sql);
}
Response.Write("<script>window.close()</script>");
}
protected void btnUpdate_Click(object sender, EventArgs e)
{
double senno = 0;
double.TryParse(txtNewSen.Text, out senno);
string empid = txtEmpID.Text;
if (senno == 0)
{
lblmsg.Text = "Invalid Seniority Number";
return;
}
string sql = string.Format("update pshr.empperso set seniorityno={0} where empid = {1}", senno, empid);
OraDBConnection.ExecQry(sql);
lblmsg.Text = "Seniority Changed";
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string loctype, locrep, locname;
string loccode;
string sql;
if (drpLocs.SelectedValue == "")
{
Utils.ShowMessageBox(this, "No Reporting Location Selected");
return;
}
if (txtNew.Text == "")
{
Utils.ShowMessageBox(this, "Enter Name of Location to Create");
return;
}
if (drploctype.SelectedValue == "0")
{
Utils.ShowMessageBox(this, "No Location Type Selected");
return;
}
locrep = drpLocs.SelectedValue;
loctype = drploctype.SelectedValue.ToString();
locname = txtNew.Text;
sql = string.Format("select cadre.get_next_loccode({0},{1}) from dual", locrep, loctype);
loccode = OraDBConnection.GetScalar(sql);
if (loccode == "")
{
Utils.ShowMessageBox(this, "Error getting next loccode");
return;
}
sql = string.Format("insert into pshr.mast_loc(loccode,locname,locabb,post,loctype,locrep,aloc) " +
"values({0},'{1}','{1}','{1}',{2},{3},'2')", loccode, locname, loctype, locrep);
if (OraDBConnection.ExecQry(sql))
{
Utils.ShowMessageBox(this, "Location Added");
}
else
{
Utils.ShowMessageBox(this, "Error Adding Location");
}
FillLocations(drploctype.SelectedValue, chkShowAll.Checked, txtFilter.Text);
return;
}
private string DoEdit()
{
bool ondepu = isDepu();
long empid = Convert.ToInt64(txtEmpID.Text.Trim());
int rno = Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text.Trim());
//fill desgcode if it is filled
string dcode = ((txtdesg.Text.Split('-')).Length >= 2) ? (txtdesg.Text.Split('-')[txtdesg.Text.Split('-').Length - 1]) : null;
//fill posting location if it is filled
string pcode = ((txtploc.Text.Split('-')).Length >= 2) ? (txtploc.Text.Split('-')[txtploc.Text.Split('-').Length - 1]) : null;
//fill pay charge location if it is filled
string pccode = "";
if (!ondepu)
{
pccode = ((txtpcloc.Text.Split('-')).Length >= 2) ? (txtpcloc.Text.Split('-')[txtpcloc.Text.Split('-').Length - 1]) : null;
}
//string sancpost = drpSancDesg.SelectedValue;
string sancpost = hidSancPost.Value;
string sql;
//sancpost (if filled) consists of "desgcode-indx",
string sancdesg = "";
string sancindx = "";
if (!ondepu)
{
sancdesg = (sancpost.Split('-').Length == 2) ? sancpost.Split('-')[0] : "";
sancindx = (sancpost.Split('-').Length == 2) ? sancpost.Split('-')[1] : "";
}
//update event in emphistory
sql = String.Format("UPDATE pshr.emphistory SET eventcode='{0}', fromdate='{1}', todate='{2}', desgcode='{3}', loccode='{4}', pcloccode='{5}'," +
"sancdesg='{6}', sancindx='{7}', oonum='{8}', odate='{9}' WHERE empid={10} AND rowno={11}", drpEvent.SelectedValue,
txtDoR.Text, txtDoJ.Text, dcode, pcode, pccode, sancdesg, sancindx, txtOoNum.Text, txtOoDate.Text, empid, rno);
bool retval = OraDBConnection.ExecQry(sql);
lblmsg.Text = retval ? "Event Edited Successfully" : "Unable to edit event";
return(rno.ToString());
}
