public Boolean reversePJVHeader(PJVHeader jvh)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update JournalVoucherHeader set DocumentStatus=" + jvh.DocumentStatus +
", forwardUser='******'" +
", commentStatus='" + jvh.CommentStatus + "'" +
", ForwarderList='" + jvh.ForwarderList + "'" +
" where DocumentID='" + jvh.DocumentID + "'" +
" and TemporaryNo=" + jvh.TemporaryNo +
" and TemporaryDate='" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "JournalVoucherHeader", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception)
{
status = false;
}
return(status);
}
public Boolean updatePJVHeaderAndDetail(PJVHeader jvh, PJVHeader prevjvh, List <PJVDetail> JVDetails)
{
Boolean status = true;
string utString = "";
try
{
string updateSQL = "update JournalVoucherHeader set Narration='" + jvh.Narration +
"', Comments='" + jvh.Comments +
"', JournalDate='" + jvh.JournalDate.ToString("yyyy-MM-dd") +
"', CommentStatus='" + jvh.CommentStatus +
"', ForwarderList='" + jvh.ForwarderList + "'" +
" where DocumentID='" + prevjvh.DocumentID + "'" +
" and TemporaryNo=" + prevjvh.TemporaryNo +
" and TemporaryDate='" + prevjvh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "JournalVoucherHeader", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "Delete from JournalVoucherDetail where DocumentID='" + prevjvh.DocumentID + "'" +
" and TemporaryNo=" + prevjvh.TemporaryNo +
" and TemporaryDate='" + prevjvh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "JournalVoucherDetail", "", updateSQL) +
Main.QueryDelimiter;
foreach (PJVDetail jvd in JVDetails)
{
updateSQL = "insert into JournalVoucherDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType) " +
"values ('" + jvd.DocumentID + "'," +
jvd.TemporaryNo + "," +
"'" + jvd.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
"'" + jvd.AccountCode + "'," +
jvd.AmountDebit + "," +
jvd.AmountCredit + ",'" + jvd.SLCode + "','" + jvd.SLType + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "JournalVoucherDetail", "", updateSQL) +
Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
MessageBox.Show("Transaction Exception Occured");
}
}
catch (Exception ex)
{
status = false;
}
return(status);
}
public static List <PJVDetail> getPJVDetail(PJVHeader jvh)
{
PJVDetail jvd;
List <PJVDetail> VDetail = new List <PJVDetail>();
try
{
string query = "";
SqlConnection conn = new SqlConnection(Login.connString);
query = "select a.RowID,a.DocumentID,a.TemporaryNo, a.TemporaryDate,a.AccountCode,b.Name,a.AmountDebit,a.AmountCredit," +
" a.SLType,a.SLCode,CASE WHEN a.SLType = 'Employee' THEN i.Name ELSE CASE WHEN a.SLType = 'Office' THEN k.Name ELSE j.Name " +
"END END AS SLName ,a.INvTempNo, a.InvTempDate " +
" from PJVDetail a LEFT OUTER JOIN " +
" AccountCode b ON a.AccountCode = b.AccountCode LEFT OUTER JOIN " +
" Employee AS i ON a.SLCode = i.EmployeeID LEFT OUTER JOIN " +
" Customer AS j ON a.SLCode = j.CustomerID LEFT OUTER JOIN " +
" Office AS k ON LTRIM(RTRIM(a.SLCode)) = LTRIM(RTRIM(k.OfficeID)) " +
"where a.DocumentID='" + jvh.DocumentID + "'" +
" and a.TemporaryNo=" + jvh.TemporaryNo +
" and a.TemporaryDate='" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
jvd = new PJVDetail();
jvd.RowID = reader.GetInt32(0);
jvd.DocumentID = reader.GetString(1);
jvd.TemporaryNo = reader.GetInt32(2);
jvd.TemporaryDate = reader.GetDateTime(3).Date;
jvd.AccountCode = reader.GetString(4);
jvd.AccountName = reader.GetString(5);
jvd.AmountDebit = reader.GetDecimal(6);
jvd.AmountCredit = reader.GetDecimal(7);
jvd.SLType = reader.IsDBNull(8) ? "" : reader.GetString(8);
jvd.SLCode = reader.IsDBNull(9) ? "" : reader.GetString(9);
jvd.SLName = reader.IsDBNull(10) ? "" : reader.GetString(10);
jvd.InvTempNo = reader.GetInt32(11);
jvd.InvTempDate = reader.GetDateTime(12).Date;
VDetail.Add(jvd);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Purchase Journal Details");
}
return(VDetail);
}
//Get Purchase journal for perticular INvoice in
public static PJVHeader getPJVHeaderPerInvoiceIN(invoiceinheader iih)
{
PJVHeader pjvh = new PJVHeader();
try
{
string query = "select RowID, DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate," +
" Narration,INVDocumentID,InvTempNo,InvTempDate,InvReferenceNo, " +
"CreateUser,CreateTime,Status,DocumentStatus" +
" from PJVHeader" +
" where INVDocumentID = '" + iih.DocumentID + "' and InvTempNo = " + iih.TemporaryNo +
" and InvTempDate = '" + iih.TemporaryDate.ToString("yyyy-MM-dd") + "'";
SqlConnection conn = new SqlConnection(Login.connString);
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
pjvh = new PJVHeader();
pjvh.RowID = reader.GetInt32(0);
pjvh.DocumentID = reader.GetString(1);
pjvh.TemporaryNo = reader.GetInt32(2);
pjvh.TemporaryDate = reader.GetDateTime(3);
pjvh.JournalNo = reader.GetInt32(4);
pjvh.JournalDate = reader.GetDateTime(5);
pjvh.Narration = reader.GetString(6);
pjvh.InvDocumentID = reader.IsDBNull(7)?"":reader.GetString(7);
pjvh.InvTempNo = reader.GetInt32(8);
pjvh.InvTempDate = reader.GetDateTime(9);
pjvh.InvReferenceNo = reader.GetInt32(10);
pjvh.CreateUser = reader.GetString(11);
pjvh.CreateTime = reader.GetDateTime(12);
pjvh.status = reader.GetInt32(13);
pjvh.DocumentStatus = reader.GetInt32(14);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Purchase Journal Header Details");
}
return(pjvh);
}
public static List <PJVDetail> getPJVDetail(PJVHeader jvh)
{
PJVDetail jvd;
List <PJVDetail> VDetail = new List <PJVDetail>();
try
{
string query = "";
SqlConnection conn = new SqlConnection(Login.connString);
query = "select RowID,DocumentID,TemporaryNo, TemporaryDate,AccountCode,AccountName,AmountDebit,AmountCredit,SLCode, SLName, SLType " +
" from ViewJournalVoucher " +
"where DocumentID='" + jvh.DocumentID + "'" +
" and TemporaryNo=" + jvh.TemporaryNo +
" and TemporaryDate='" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
jvd = new PJVDetail();
jvd.RowID = reader.GetInt32(0);
jvd.DocumentID = reader.GetString(1);
jvd.TemporaryNo = reader.GetInt32(2);
jvd.TemporaryDate = reader.GetDateTime(3).Date;
jvd.AccountCode = reader.GetString(4);
jvd.AccountName = reader.GetString(5);
jvd.AmountDebit = reader.GetDecimal(6);
jvd.AmountCredit = reader.GetDecimal(7);
jvd.SLCode = reader.IsDBNull(8)?"":reader.GetString(8);
jvd.SLName = reader.IsDBNull(9) ? "" : reader.GetString(9);
jvd.SLType = reader.IsDBNull(10) ? "" : reader.GetString(10);
VDetail.Add(jvd);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Journal Details");
}
return(VDetail);
}
public static PJVHeader getPJVHeaderForTrialBalance(PJVHeader jvhTemp)
{
PJVHeader jvh = new PJVHeader();
try
{
string query = "select distinct DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate," +
" Narration,status,DocumentStatus " +
" from JournalVoucherHeader" +
" where DocumentID = '" + jvhTemp.DocumentID + "' and JournalNo = " + jvhTemp.JournalNo +
" and JournalDate = '" + jvhTemp.JournalDate.ToString("yyyy-MM-dd") + "'";
SqlConnection conn = new SqlConnection(Login.connString);
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
try
{
jvh.DocumentID = reader.GetString(0);
jvh.TemporaryNo = reader.GetInt32(1);
jvh.TemporaryDate = reader.GetDateTime(2);
jvh.JournalNo = reader.GetInt32(3);
jvh.JournalDate = reader.GetDateTime(4);
jvh.Narration = reader.GetString(5);
jvh.status = reader.GetInt32(6);
jvh.DocumentStatus = reader.GetInt32(7);
}
catch (Exception ex)
{
}
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Journal Header Details");
}
return(jvh);
}
public static Boolean UpdatePJVHeaderDetailDuringApproveInvoiceIN(List <PJVDetail> pjvDetail, PJVHeader pjvh)
{
//call when invoice inward is saved
//Invoice types MRN,Work Order, PO General
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
updateSQL = "Delete from PJVDetail where DocumentID='" + pjvh.DocumentID + "'" +
" and TemporaryNO=" + pjvh.TemporaryNo +
" and TemporaryDate='" + pjvh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
//--
foreach (PJVDetail jvd in pjvDetail)
{
updateSQL = "insert into PJVDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType,INVDocumentID,InvTempNo,InvTempDate) " +
"values ('" + jvd.DocumentID + "'," +
jvd.TemporaryNo + "," +
"'" + jvd.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
"'" + jvd.AccountCode + "'," +//sundry creditors
jvd.AmountDebit + "," +
jvd.AmountCredit + ",'" + jvd.SLCode + "','" + jvd.SLType + "','" + jvd.InvDocumentID + "'," +
jvd.InvTempNo + "," +
"'" + jvd.InvTempDate.ToString("yyyy-MM-dd") + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
MessageBox.Show("Transaction Exception Occured");
}
return(status);
}
public static Boolean InsertPJVHeaderAndDetail(PJVHeader jvh)
{
//call when invoice inward is saved
//Invoice types MRN,Work Order, PO General
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
updateSQL = "Delete from PJVHeader where InvDocumentID='" + jvh.InvDocumentID + "'" +
" and InvTempNo=" + jvh.InvTempNo +
" and InvTempDate='" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
updateSQL = "Delete from PJVDetail where InvDocumentID='" + jvh.InvDocumentID + "'" +
" and InvTempNo=" + jvh.InvTempNo +
" and InvTempDate='" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
//--
updateSQL = "insert into PJVHeader " +
"(DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate,Narration," +
"InvDocumentID,InvTempNo,InvTempDate,InvReferenceNo," +
"Comments,CommentStatus,CreateUser,CreateTime,ForwarderList,DocumentStatus,Status)" +
" values (" +
"'" + jvh.DocumentID + "'," +
jvh.TemporaryNo + "," +
"'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
jvh.JournalNo + "," +
"'" + jvh.JournalDate.ToString("yyyy-MM-dd") + "'," +
"'" + jvh.Narration + "'," +
"'" + jvh.InvDocumentID + "'," +
jvh.InvTempNo + "," +
"'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'," +
jvh.InvReferenceNo + "," +
"'" + jvh.Comments + "'," +
"'" + jvh.CommentStatus + "'," +
"'" + Login.userLoggedIn + "'," +
"GETDATE()" + "," +
"'" + jvh.ForwarderList + "'," +
jvh.DocumentStatus + "," +
jvh.status + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
//////utString = utString +
//////ActivityLogDB.PrepareActivityLogQquerString("insert", "PJVHeader", "", updateSQL) +
//////Main.QueryDelimiter;
jvaccmapping jvAcc = AutoJVAccMappingDB.getjvaccmappingPerDocument(jvh.DocumentID, jvh.InvDocumentID);
if (jvAcc.AccountCodeDebit == null || jvAcc.AccountCodeDebit.Trim().Length == 0 || jvAcc.AccountCodeCredit == null || jvAcc.AccountCodeCredit.Length == 0)
{
MessageBox.Show("Debit and credit account not mapped for this document.\n Failed to update Purchase journal.");
return(false);
}
updateSQL = "insert into PJVDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType,INVDocumentID,InvTempNo,InvTempDate) " +
"values ('" + jvh.DocumentID + "'," +
jvh.TemporaryNo + "," +
"'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
/// "'11111111110248'," +//sundry creditors // credit
"'" + jvAcc.AccountCodeCredit + "'," +
0 + "," +
(jvh.Amtount) + ",'" + jvh.Customer + "','Party','" + jvh.InvDocumentID + "'," +
jvh.InvTempNo + "," +
"'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
//////utString = utString +
//////ActivityLogDB.PrepareActivityLogQquerString("insert", "PJVDetail", "", updateSQL) +
//////Main.QueryDelimiter;
//--
updateSQL = "insert into PJVDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType,INVDocumentID,InvTempNo,InvTempDate) " +
"values ('" + jvh.DocumentID + "'," +
jvh.TemporaryNo + "," +
"'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
//"'11111111110557'," + //purchase ac
"'" + jvAcc.AccountCodeDebit + "'," +
(jvh.Amtount - jvh.TaxAmount) + "," +
0 + ",'','','" + jvh.InvDocumentID + "'," +
jvh.InvTempNo + "," +
"'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
//////utString = utString +
//////ActivityLogDB.PrepareActivityLogQquerString("insert", "PJVDetail", "", updateSQL) +
//////Main.QueryDelimiter;
//Updating SJV references in INvoice out
updateSQL = "update InvoiceInHeader set PJVTNo=" + jvh.TemporaryNo +
", PJVTDate='" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'" +
", PJVNo='" + jvh.JournalNo + "'" +
", PJVDate='" + jvh.JournalDate.ToString("yyyy-MM-dd") + "'" +
" where DocumentID='" + jvh.InvDocumentID + "'" +
" and TemporaryNo=" + jvh.InvTempNo +
" and TemporaryDate='" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
try
{
TaxItemDB taxitemdb = new TaxItemDB();
List <taxitem> TaxItems = taxitemdb.getTaxItems();
string[] lst1 = jvh.TaxDetail.Split('\n');
for (int i = 0; i < lst1.Length - 1; i++)
{
string taxCode = "Not Found";
string[] lst2 = lst1[i].Split('-');
int ind = searchList(TaxItems, lst2[0]);
if (ind >= 0)
{
taxCode = TaxItems[ind].AccountCodeIN;
}
updateSQL = "insert into PJVDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType,INVDocumentID,InvTempNo,InvTempDate) " +
"values ('" + jvh.DocumentID + "'," +
jvh.TemporaryNo + "," +
"'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
"'" + taxCode + "'," +//sundry creditors
lst2[1] + "," +
0 + ",'','','" + jvh.InvDocumentID + "'," +
jvh.InvTempNo + "," +
"'" + jvh.InvTempDate.ToString("yyyy-MM-dd") + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
}
}
catch (Exception ex)
{
MessageBox.Show("InsertPJVHeaderAndDetail() : Error creating tax entries - " + ex.ToString());
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
MessageBox.Show("Transaction Exception Occured");
}
return(status);
}
public List <PJVHeader> getFilteredPJVHeader(string userList, int opt, string userCommentStatusString)
{
PJVHeader jvh;
List <PJVHeader> JVHeaders = new List <PJVHeader>();
try
{
//approved user comment status string
string acStr = "";
try
{
acStr = userCommentStatusString.Substring(0, userCommentStatusString.Length - 2) + "1" + Main.delimiter2;
}
catch (Exception ex)
{
acStr = "";
}
//-----
string query1 = "select distinct DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate," +
" Narration,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName,ForwarderList,status,DocumentStatus,CommentStatus " +
" from ViewJournalVoucher" +
" where ((ForwardUser='******' and DocumentStatus between 2 and 98) " +
" or (CreateUser='******' and DocumentStatus=1)" +
" or (CommentStatus like '%" + userCommentStatusString + "%' and DocumentStatus between 1 and 98)) order by TemporaryDate desc,DocumentID asc,TemporaryNo desc";
string query2 = "select distinct DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate," +
" Narration,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName,ForwarderList,status,DocumentStatus,CommentStatus " +
" from ViewJournalVoucher" +
" where ((createuser='******' and DocumentStatus between 2 and 98 ) " +
" or (ForwarderList like '%" + userList + "%' and DocumentStatus between 2 and 98 and ForwardUser <> '" + Login.userLoggedIn + "')" +
" or (commentStatus like '%" + acStr + "%' and DocumentStatus between 1 and 98)) order by TemporaryDate desc,DocumentID asc,TemporaryNo desc";
string query3 = "select distinct DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate," +
" Narration,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName,ForwarderList,status,DocumentStatus,CommentStatus " +
" from ViewJournalVoucher" +
" where ((createuser='******'" +
" or ForwarderList like '%" + userList + "%'" +
" or commentStatus like '%" + acStr + "%'" +
" or approveUser='******')" +
" and DocumentStatus = 99) order by JournalDate desc,DocumentID asc,JournalNo desc";
string query6 = "select distinct DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate," +
" Narration,CreateUser,ForwardUser,ApproveUser,CreatorName,CreateTime,ForwarderName,ApproverName,ForwarderList,status,DocumentStatus,CommentStatus " +
" from ViewJournalVoucher" +
" where DocumentStatus = 99 order by JournalDate desc,DocumentID asc,JournalNo desc";
SqlConnection conn = new SqlConnection(Login.connString);
string query = "";
switch (opt)
{
case 1:
query = query1;
break;
case 2:
query = query2;
break;
case 3:
query = query3;
break;
case 6:
query = query6;
break;
default:
query = "";
break;
}
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
try
{
jvh = new PJVHeader();
jvh.DocumentID = reader.GetString(0);
jvh.TemporaryNo = reader.GetInt32(1);
jvh.TemporaryDate = reader.GetDateTime(2);
jvh.JournalNo = reader.GetInt32(3);
jvh.JournalDate = reader.GetDateTime(4);
jvh.Narration = reader.GetString(5);
jvh.CreateUser = reader.GetString(6);
jvh.ForwardUser = reader.GetString(7);
jvh.ApproveUser = reader.GetString(8);
jvh.CreatorName = reader.GetString(9);
jvh.CreateTime = reader.GetDateTime(10);
jvh.ForwarderName = reader.GetString(11);
jvh.ApproverName = reader.GetString(12);
if (!reader.IsDBNull(13))
{
jvh.ForwarderList = reader.GetString(13);
}
else
{
jvh.ForwarderList = "";
}
jvh.status = reader.GetInt32(14);
jvh.DocumentStatus = reader.GetInt32(15);
if (!reader.IsDBNull(16))
{
jvh.CommentStatus = reader.GetString(16);
}
else
{
jvh.CommentStatus = "";
}
JVHeaders.Add(jvh);
}
catch (Exception ex)
{
}
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show("Error querying Journal Header Details");
}
return(JVHeaders);
}
public Boolean InsertPJVHeaderAndDetail(PJVHeader jvh, List <PJVDetail> JVDetails)
{
Boolean status = true;
string utString = "";
string updateSQL = "";
try
{
jvh.TemporaryNo = DocumentNumberDB.getNumber(jvh.DocumentID, 1);
if (jvh.TemporaryNo <= 0)
{
MessageBox.Show("Error in Creating New Number");
return(false);
}
updateSQL = "update DocumentNumber set TempNo =" + jvh.TemporaryNo +
" where FYID='" + Main.currentFY + "' and DocumentID='" + jvh.DocumentID + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("update", "DocumentNumber", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "insert into JournalVoucherHeader " +
"(DocumentID,TemporaryNo,TemporaryDate,JournalNo,JournalDate,Narration," +
"Comments,CommentStatus,CreateUser,CreateTime,ForwarderList,DocumentStatus,Status)" +
" values (" +
"'" + jvh.DocumentID + "'," +
jvh.TemporaryNo + "," +
"'" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
jvh.JournalNo + "," +
"'" + jvh.JournalDate.ToString("yyyy-MM-dd") + "'," +
"'" + jvh.Narration + "'," +
"'" + jvh.Comments + "'," +
"'" + jvh.CommentStatus + "'," +
"'" + Login.userLoggedIn + "'," +
"GETDATE()" + "," +
"'" + jvh.ForwarderList + "'," +
jvh.DocumentStatus + "," +
jvh.status + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "JournalVoucherHeader", "", updateSQL) +
Main.QueryDelimiter;
updateSQL = "Delete from JournalVoucherDetail where DocumentID='" + jvh.DocumentID + "'" +
" and TemporaryNo=" + jvh.TemporaryNo +
" and TemporaryDate='" + jvh.TemporaryDate.ToString("yyyy-MM-dd") + "'";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("delete", "JournalVoucherDetail", "", updateSQL) +
Main.QueryDelimiter;
foreach (PJVDetail jvd in JVDetails)
{
updateSQL = "insert into JournalVoucherDetail " +
"(DocumentID,TemporaryNo,TemporaryDate,AccountCode,AmountDebit,AmountCredit,SLCode,SLType) " +
"values ('" + jvd.DocumentID + "'," +
jvh.TemporaryNo + "," +
"'" + jvd.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
"'" + jvd.AccountCode + "'," +
jvd.AmountDebit + "," +
jvd.AmountCredit + ",'" + jvd.SLCode + "','" + jvd.SLType + "')";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "JournalVoucherDetail", "", updateSQL) +
Main.QueryDelimiter;
}
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
status = false;
MessageBox.Show("Transaction Exception Occured");
}
return(status);
}
