public List <DocCancel> getDocCancelValues()
{
DocCancel Docval;
List <DocCancel> DocValues = new List <DocCancel>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string empLogedin = Login.userLoggedIn;
string query = "select distinct a.DocumentID,a.DocumentName,a.TableName from Document a , DocEmpMapping b ,DocumentUC c" +
" where a.DocumentID = b.DocumentID and" +
" a.IsReversible = 1 and b.SeniorEmployeeID = '" + Login.empLoggedIn + "' or " +
"c.UserID = (select distinct UserID from ViewUserEmployeeList a where a.EmployeeID = '" + Login.empLoggedIn + "' )" +
"and c.Status = 1 and a.TableName != 'NULL'and a.IsReversible = 1 order by a.DocumentName";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
Docval = new DocCancel();
Docval.DocumentID = reader.GetString(0);
Docval.DocumentName = reader.GetString(1);
Docval.TableName = reader.GetString(2);
DocValues.Add(Docval);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(DocValues);
}
public Boolean updateReceiptVoucherForCancel(DocCancel du)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update " + du.TableName + " set Status= 98 where RowID = " + du.RowID + "";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", du.TableName, "", updateSQL) + Main.QueryDelimiter;
updateSQL = "Delete from InvoiceOutReceipts where RVTemporaryNo='" + du.TemporaryNo + "'" +
" and RVTemporaryDate='" + du.TemporaryDate.ToString("yyyy-MM-dd") + "' and RVDocumentID = '" + du.DocumentID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "InvoiceOutReceipts", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public Boolean updateDocForCancel(DocCancel du)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update " + du.TableName + " set Status= 98 where RowID = " + du.RowID + "";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString + ActivityLogDB.PrepareActivityLogQquerString("update", du.TableName, "", updateSQL) + Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public List <DocCancel> getDocumentInfo(string tablename, string documentID)
{
DocCancel tb;
DocumentUnlockDB dbrecord = new DocumentUnlockDB();
List <DocCancel> tbdata = new List <DocCancel>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string empLogedin = Login.userLoggedIn;
string query = "select DocumentID,TemporaryNo,TemporaryDate,ForwardUser,ForwarderList,RowID from " + tablename +
" where DocumentID = '" + documentID + "' and DocumentStatus BETWEEN 1 AND 98 and Status in (0,96) order by TemporaryNo desc, TemporaryDate desc";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
tb = new DocCancel();
tb.DocumentID = reader.IsDBNull(0) ? "" : reader.GetString(0);
tb.TemporaryNo = reader.GetInt32(1);
tb.TemporaryDate = reader.GetDateTime(2);
tb.TableName = tablename;
tb.ForwardUser = reader.IsDBNull(3) ? "" : reader.GetString(3);
tb.forwarderlist = reader.IsDBNull(4) ? "" : reader.GetString(4);
tb.RowID = reader.IsDBNull(5) ? 0 : reader.GetInt32(5);
tbdata.Add(tb);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(tbdata);
}