private void btnSave_Click(object sender, EventArgs e)
{
if (fncBlank())
{
return;
}
ArrayList arQuery = new ArrayList();
GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection();
string sqlQuery = "";
Int32 NewId = 0;
string sqlQuery1 = "";
Int64 ChkLock = 0;
sqlQuery1 = "Select dbo.fncProcessLock (" + Common.Classes.clsMain.intComId + ", 'Casual Attend Lock','" + clsProc.GTRDate(dtFromDate.Value.ToString()) + "')";
ChkLock = clsCon.GTRCountingDataLarge(sqlQuery1);
if (ChkLock == 1)
{
MessageBox.Show("Process Lock. Please communicate with Administrator.");
return;
}
try
{
{
//add new
//sqlQuery = "Select Isnull(Max(advID),0)+1 As NewId from tblSal_Adv";
//NewId = clsCon.GTRCountingData(sqlQuery);
DateTime dt1 = dtFromDate.DateTime;
DateTime dt2 = dtLast.DateTime;
TimeSpan ts = dt1 - dt2;
int days = ts.Days;
if (days > 1)
{
MessageBox.Show("Please Run The Process For " + clsProc.GTRDate(dtLast.DateTime.AddDays(1).ToString()) + " ");
dtFromDate.Focus();
dtFromDate.Value = (dtLast.DateTime.AddDays(1));
}
if (chkMonthly.Checked == true)
{
//int ICount = 0; /// For the Process PrDate Count
//int ICount2 = 0; ///' For the Process PrDate Count
int Y = 0, X = 0;
//double Z = 1;
X = dtFromDate.DateTime.Day;
Y = dtToDate.DateTime.Day;
while (X <= Y)
{
lblProcess.Text = "Processing " + clsProc.GTRDate(dtLast.DateTime.ToString()) + " .....";
dsDetails = new System.Data.DataSet();
{
sqlQuery = "Exec prcProcessAttendCasual " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtFromDate.Value.ToString()) + "'";
int i = clsCon.GTRSaveDataWithSQLCommand(sqlQuery);
//sqlQuery = "Exec prcProcessAttendShift " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtFromDate.Value.ToString()) + "'";
//clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery);
//dsDetails.Tables[0].TableName = "tblSalAdv";
}
dtFromDate.Value = dtFromDate.DateTime.AddDays(1);
X++;
//Z++;
}
//' Call DaySelector
// Call Praram
// CON.Execute "PrProcessAtt '" & AmzDate(DTPicker1.value) & "'"
// CON.Execute "BuyerJobcardPrint '" & AmzDate(DTPicker1.value) & "'"
// 'If RSCounter(rspcs2) = 0 Then
// Call Connect
// ICount2 = TotalRecord("tblPrDate", "PrDate", AmzDate(DTPicker1.value))
// If ICount2 < 1 Then
// CON.Execute "insert tblPrDate Values ('" & AmzDate(DTPicker1.value) & "')"
// End If
// 'Call ProcessAtt(0)
// End If
// Next
}
else
{
lblProcess.Text = "Processing " + clsProc.GTRDate(dtLast.DateTime.ToString()) + " .....";
dsDetails = new System.Data.DataSet();
{
if (OptSts.Value == "H" || OptSts.Value == "R" || OptSts.Value == "W")
{
sqlQuery = "delete tblProssType where ProssDt = '" + clsProc.GTRDate(dtFromDate.Value.ToString()) + "'; insert into tblProssType(ProssDt,DaySts,DayStsB,IsLock) values ('" + clsProc.GTRDate(dtFromDate.Value.ToString()) + "','" + (OptSts.Value.ToString()) + "','" + (OptSts.Value.ToString()) + "',0)";
clsCon.GTRFillDatasetWithSQLCommand(ref dsDetails, sqlQuery);
}
sqlQuery = "Exec prcProcessAttendCasual " + Common.Classes.clsMain.intComId + ",'" + clsProc.GTRDate(dtFromDate.Value.ToString()) + "'";
int i = clsCon.GTRSaveDataWithSQLCommand(sqlQuery);
}
}
MessageBox.Show("Process complete");
}
prcClearData();
//cboEmpID.Focus();
prcLoadList();
prcLoadCombo();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
arQuery = null;
clsCon = null;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (fncBlank())
{
return;
}
ArrayList arQuery = new ArrayList();
GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection();
string sqlQuery = "";
Int32 NewId = 0;
Int64 ChkRel = 0;
try
{
//Member Master Table
if (btnSave.Text.ToString() != "&Save")
{
//Update data
sqlQuery = " Update tblEmp_Released Set dtReleased = '" + clsProc.GTRDate(dtReleasedDate.Value.ToString()) + "',remarks = '" + txtRemarks.Text.ToString() + "' Where RelID = " + Int32.Parse(txtId.Text.ToString());
arQuery.Add(sqlQuery);
// Insert Information To Log File
sqlQuery = "Insert Into tblUser_Trans_Log (LUserId, formName, tranStatement, PCName, tranType,EmpId)"
+ " Values (" + Common.Classes.clsMain.intUserId + ", '" + this.Name.ToString() + "','" + sqlQuery.Replace("'", "|") + "','" + Common.Classes.clsMain.strComputerName + "','Update','" + cboEmpID.Value.ToString() + "')";
arQuery.Add(sqlQuery);
sqlQuery = " Update tblEmp_info Set dtReleased = '" + clsProc.GTRDate(dtReleasedDate.Value.ToString()) + "', IsInactive = 1 Where empid = '" + cboEmpID.Value.ToString() + "' and ComId = " + Common.Classes.clsMain.intComId + "";
arQuery.Add(sqlQuery);
// Insert Information To Log File
sqlQuery = "Insert Into tblUser_Trans_Log (LUserId, formName, tranStatement, PCName, tranType,EmpId)"
+ " Values (" + Common.Classes.clsMain.intUserId + ", '" + this.Name.ToString() + "','" + sqlQuery.Replace("'", "|") + "','" + Common.Classes.clsMain.strComputerName + "','Update','" + cboEmpID.Value.ToString() + "')";
arQuery.Add(sqlQuery);
//Transaction with database
clsCon.GTRSaveDataWithSQLCommand(arQuery);
MessageBox.Show("Data Updated Succefully.");
}
else
{
sqlQuery = "Select dbo.fncCheckEmpRel (" + Common.Classes.clsMain.intComId + ", '" + cboEmpID.Value.ToString() + "')";
ChkRel = clsCon.GTRCountingDataLarge(sqlQuery);
if (ChkRel == 1)
{
MessageBox.Show("This Employee ID already Exist. Please input another Employee ID.");
return;
}
//add new
sqlQuery = "Select Isnull(Max(RelID),0)+1 As NewId from tblEmp_Released";
NewId = clsCon.GTRCountingData(sqlQuery);
//Insert data
sqlQuery = "Insert Into tblEmp_Released ( aId,RelID, empid, dtReleased, Remarks,ComId ,LUserId,PcName) "
+ " Values (" + NewId + ", " + NewId + ", '" + cboEmpID.Value.ToString() + "', '" + clsProc.GTRDate(dtReleasedDate.Value.ToString()) + "', '" + txtRemarks.Text.ToString() + "'," + Common.Classes.clsMain.intComId + "," + Common.Classes.clsMain.intUserId + ",'" + Common.Classes.clsMain.strComputerName + "')";
arQuery.Add(sqlQuery);
// Insert Information To Log File
sqlQuery = "Insert Into tblUser_Trans_Log (LUserId, formName, tranStatement, PCName, tranType,EmpId)"
+ " Values (" + Common.Classes.clsMain.intUserId + ", '" + this.Name.ToString() + "','" + sqlQuery.Replace("'", "|") + "','" + Common.Classes.clsMain.strComputerName + "','Insert','" + cboEmpID.Value.ToString() + "')";
arQuery.Add(sqlQuery);
sqlQuery = " Update tblEmp_info Set dtReleased = '" + clsProc.GTRDate(dtReleasedDate.Value.ToString()) + "', IsInactive = 1 Where empid = '" + cboEmpID.Value.ToString() + "' and ComId = " + Common.Classes.clsMain.intComId + "";
arQuery.Add(sqlQuery);
// Insert Information To Log File
sqlQuery = "Insert Into tblUser_Trans_Log (LUserId, formName, tranStatement, PCName, tranType,EmpId)"
+ " Values (" + Common.Classes.clsMain.intUserId + ", '" + this.Name.ToString() + "','" + sqlQuery.Replace("'", "|") + "','" + Common.Classes.clsMain.strComputerName + "','Insert','" + cboEmpID.Value.ToString() + "')";
arQuery.Add(sqlQuery);
//Transaction with database
clsCon.GTRSaveDataWithSQLCommand(arQuery);
MessageBox.Show("Data Saved Successfully.");
}
prcClearData();
cboEmpID.Focus();
prcLoadList();
prcLoadCombo();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
arQuery = null;
clsCon = null;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (fncBlank())
{
return;
}
ArrayList arQuery = new ArrayList();
GTRLibrary.clsConnection clsCon = new GTRLibrary.clsConnection();
string sqlQuery = "";
Int64 NewId = 0;
Int64 ChkCard = 0;
DateTime firstDay = new DateTime(dtCardAssign.DateTime.Year, dtCardAssign.DateTime.Month, 1);
dtFrom.Value = firstDay;
sqlQuery = "Select dbo.fncCheckCardAssign (" + Common.Classes.clsMain.intComId + ", '" + this.txtCard.Text.ToString() + "')";
ChkCard = clsCon.GTRCountingDataLarge(sqlQuery);
if (ChkCard == 1)
{
MessageBox.Show("This Employee Card already Exist. Please input another Punch Card Number.");
return;
}
try
{
//Update data
sqlQuery = "Update tblEmp_Info Set CardNo = '" + txtCard.Text.ToString() + "' + 'Rel' Where ComId = " + Common.Classes.clsMain.intComId + " and CardNo = '" + txtCard.Text.ToString() + "' and Len(CardNo)=10 and isinactive = 1";
arQuery.Add(sqlQuery);
sqlQuery = "Update tblEmp_Info Set dtCardAssign = '" + clsProc.GTRDate(dtCardAssign.Value.ToString()) + "',CardNo = '" + txtCard.Text.ToString() + "' Where ComId = " + Common.Classes.clsMain.intComId + " and EmpId = " + Int32.Parse(txtId.Text.ToString());
arQuery.Add(sqlQuery);
// Insert Information To Log File
sqlQuery = "Insert Into tblUser_Trans_Log (LUserId, formName, tranStatement, PCName, tranType,EmpId)"
+ " Values (" + Common.Classes.clsMain.intUserId + ", '" + this.Name.ToString() + "','" + sqlQuery.Replace("'", "|") + "','" + Common.Classes.clsMain.strComputerName + "','Update','" + txtId.Value.ToString() + "')";
arQuery.Add(sqlQuery);
sqlQuery = "Update R Set R.EmpId = E.EmpId from tblRawData R,tblEmp_Info E Where R.CardNo = E.CardNo and E.CardNo = '" + txtCard.Text.ToString() + "' and R.dtPunchDate >= '" + clsProc.GTRDate(dtFrom.Value.ToString()) + "' and E.ComId = " + Common.Classes.clsMain.intComId + "";
arQuery.Add(sqlQuery);
//Transaction with database
clsCon.GTRSaveDataWithSQLCommand(arQuery);
MessageBox.Show("Data Updated Succefully.");
prcClearData();
txtEmpCode.Focus();
prcLoadList();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
finally
{
arQuery = null;
clsCon = null;
}
}
