public static List <proformainvoice> getProformaInfo(int TempNo, string DOCID)
{
proformainvoice documentrec;
List <proformainvoice> Documents = new List <proformainvoice>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "Select b.Name,a.InvoiceAmount,a.InvoiceNo,a.InvoiceDate,a.TemporaryDate from InvoiceOutHeader a,Customer b where b.CustomerID=a.Consignee and a.DocumentID='" + DOCID + "' and a.TemporaryNo='" + TempNo + "'";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
documentrec = new proformainvoice();
documentrec.customername = reader.GetString(0);
documentrec.InvoiceAmt = reader.GetDouble(1);
documentrec.DocumentNo = reader.GetInt32(2);
documentrec.DocumentDate = reader.GetDateTime(3);
documentrec.TemporaryDate = reader.GetDateTime(4);
Documents.Add(documentrec);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(Documents);
}
public List <proformainvoice> getProformaDocuments()
{
proformainvoice documentrec;
List <proformainvoice> Documents = new List <proformainvoice>();
try
{
SqlConnection conn = new SqlConnection(Login.connString);
string query = "Select DocumentID,TemporaryNo,TemporaryDate,DocumentNo,DocumentDate from ProformaDocuments order by TemporaryNo";
SqlCommand cmd = new SqlCommand(query, conn);
conn.Open();
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
documentrec = new proformainvoice();
documentrec.DocumentID = reader.GetString(0);
documentrec.TemporaryNo = reader.GetInt32(1);
documentrec.TemporaryDate = reader.GetDateTime(2);
documentrec.DocumentNo = reader.GetInt32(3);
documentrec.DocumentDate = reader.GetDateTime(4);
Documents.Add(documentrec);
}
conn.Close();
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
return(Documents);
}
public Boolean insertDocument(proformainvoice doc)
{
Boolean status = true;
string utString = "";
try
{
DateTime cdt = DateTime.Now;
string updateSQL = "insert into ProformaDocuments (DocumentID,TemporaryNo,TemporaryDate,DocumentNo,DocumentDate,CreateTime,CreateUser)" +
"values (" +
"'" + doc.DocumentID + "'," +
"'" + doc.TemporaryNo + "'," +
"'" + doc.TemporaryDate.ToString("yyyy-MM-dd") + "'," +
doc.DocumentNo + "," +
"'" + doc.DocumentDate.ToString("yyyy-MM-dd") + "'," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "ProformaDocuments", "", 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 validateDocument(proformainvoice doc)
{
Boolean status = true;
try
{
if (doc.DocumentNo == 0)
{
return(false);
}
if (doc.DocumentDate == DateTime.MinValue)
{
return(false);
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
return(false);
}
return(status);
}