public static List <Weighment> GetWeight()
{
List <Weighment> Weight = new List <Weighment>();
using (SQLiteHelper SQLite = new SQLiteHelper())
{
DataTable tblWeighment = SQLite.Select("SELECT Max(TicketNumber) AS TicketNumber,Id FROM Weighment ");
if (tblWeighment.Rows.Count > 0)
{
foreach (DataRow row in tblWeighment.Rows)
{
Weighment Weights = new Weighment();
int Id = 0;
int.TryParse(row["Id"].ToString(), out Id);
Weights.Id = Id;
int TicketNumber = 0;
int.TryParse(row["TicketNumber"].ToString(), out TicketNumber);
if (TicketNumber > 0)
{
Weights.TicketNumber = Convert.ToInt32(row["TicketNumber"]);
}
else
{
Weights.TicketNumber = 0;
}
Weight.Add(Weights);
}
}
}
return(Weight);
}
public static List <Weighment> WeighmentRecordCount()
{
List <Weighment> Weight = new List <Weighment>();
using (SQLiteHelper SQLite = new SQLiteHelper())
{
DataTable tblWeighment = SQLite.Select("SELECT Count(*) AS RecordCount FROM Weighment ");
if (tblWeighment.Rows.Count > 0)
{
foreach (DataRow row in tblWeighment.Rows)
{
Weighment Weights = new Weighment();
int RecordCount = 0;
int.TryParse(row["RecordCount"].ToString(), out RecordCount);
Weights.Id = RecordCount;
Weight.Add(Weights);
}
}
}
return(Weight);
}
public static List <Weighment> WeighmentCreatedOn()
{
List <Weighment> Weight = new List <Weighment>();
using (SQLiteHelper SQLite = new SQLiteHelper())
{
DataTable tblWeighment = SQLite.Select("SELECT CreatedOn FROM Weighment ");
if (tblWeighment.Rows.Count > 0)
{
foreach (DataRow row in tblWeighment.Rows)
{
Weighment Weights = new Weighment();
DateTime CreatedOn;
DateTime.TryParse(row["CreatedOn"].ToString(), out CreatedOn);
Weights.FirstDateTime = CreatedOn;
Weight.Add(Weights);
}
}
}
return(Weight);
}
public static Weighment PendingSecondWeight(string vNumber, int count)
{
Weighment weighment = new Weighment();
count = 0;
using (SQLiteHelper SQLite = new SQLiteHelper())
{
DataTable tblWeighment = SQLite.Select("SELECT * FROM Weighment Where ReferenceNumber ='1'");
if (tblWeighment.Rows.Count > 0)
{
count = 1;
}
}
return(weighment);
}
public static bool UpdateWeighment(Weighment WeighmentEntry, string LoggedInUser)
{
bool Result = false;
using (SQLiteHelper SQLite = new SQLiteHelper())
{
Dictionary <string, object> WeighmentDictionary = new Dictionary <string, object>();
WeighmentDictionary.Add("TicketDate", WeighmentEntry.TicketDate.ToString("yyyy-MM-dd H:mm"));
WeighmentDictionary.Add("TicketNumber", WeighmentEntry.TicketNumber);
WeighmentDictionary.Add("ReferenceNumber", WeighmentEntry.ReferenceNumber);
WeighmentDictionary.Add("ClientId", WeighmentEntry.ClientId);
WeighmentDictionary.Add("ModifiedBy", LoggedInUser);
WeighmentDictionary.Add("ModifiedOn", DateTime.Now.ToString("yyyy-MM-dd H:mm"));
WeighmentDictionary.Add("RevisionNumber", "1");
WeighmentDictionary.Add("ContainerNo", WeighmentEntry.ContainerNo);
WeighmentDictionary.Add("BiltyNo", WeighmentEntry.BiltyNo);
WeighmentDictionary.Add("SealNo", WeighmentEntry.SealNo);
WeighmentDictionary.Add("DriverName", WeighmentEntry.DriverName);
WeighmentDictionary.Add("NoOfBags", WeighmentEntry.NoOfBags);
WeighmentDictionary.Add("Remark", WeighmentEntry.Remark);
WeighmentDictionary.Add("ProductName", WeighmentEntry.ProductName);
WeighmentDictionary.Add("FirstWeight", WeighmentEntry.FirstWeight);
WeighmentDictionary.Add("FirstDateTime", WeighmentEntry.FirstDateTime.ToString("yyyy-MM-dd H:mm"));
WeighmentDictionary.Add("FirstType", WeighmentEntry.FirstType);
WeighmentDictionary.Add("SecondWeight", WeighmentEntry.SecondWeight);
WeighmentDictionary.Add("SecondDateTime", WeighmentEntry.SecondDateTime.ToString("yyyy-MM-dd H:mm"));
WeighmentDictionary.Add("SecondType", WeighmentEntry.SecondType);
WeighmentDictionary.Add("Weight", WeighmentEntry.Weight);
WeighmentDictionary.Add("MWeight", WeighmentEntry.MWeight);
WeighmentDictionary.Add("BarCode", WeighmentEntry.BarCode);
WeighmentDictionary.Add("From", WeighmentEntry.From);
WeighmentDictionary.Add("To", WeighmentEntry.To);
WeighmentDictionary.Add("Amount", WeighmentEntry.Amount);
WeighmentDictionary.Add("ReceivedAmount", WeighmentEntry.ReceivedAmount);
Dictionary <string, object> WhereClause = new Dictionary <string, object>();
WhereClause.Add("Id", WeighmentEntry.Id);
SQLite.Update("Weighment", WeighmentDictionary, WhereClause);
}
return(Result);
}
public static List <Weighment> GetWeighments()
{
List <Weighment> Weighments = new List <Weighment>();
using (SQLiteHelper SQLite = new SQLiteHelper())
{
//DataTable tblWeighments = SQLite.Select("SELECT wt.RevisionNumber, wt.Id, wt.ClientId, wt.TicketNumber, wt.ReferenceNumber, wt.TicketDate, cl.Name AS ClientName FROM Weighment wt INNER JOIN Client cl ON wt.ClientId = cl.Id");
DataTable tblWeighments = SQLite.Select("SELECT wt.RevisionNumber, wt.Id, wt.ClientId, wt.TicketNumber, wt.ReferenceNumber, wt.TicketDate, cl.Name AS ClientName FROM Weighment wt");
if (tblWeighments.Rows.Count > 0)
{
foreach (DataRow row in tblWeighments.Rows)
{
Weighment weighment = new Weighment();
int Id = 0;
int.TryParse(row["Id"].ToString(), out Id);
weighment.Id = Id;
DateTime ticketDate = DateTime.Now;
DateTime.TryParse(row["TicketDate"].ToString(), out ticketDate);
weighment.TicketDate = ticketDate;
weighment.TicketNumber = Convert.ToInt32(row["Id"]);
weighment.ReferenceNumber = row["ReferenceNumber"].ToString();
//int clientId = 0;
//int.TryParse(row["ClientId"].ToString(), out clientId);
//weighment.ClientId = clientId;
//weighment.ClientName = row["ClientName"].ToString();
weighment.ClientId = row["ClientId"].ToString();
int RevisionNumber = 0;
int.TryParse(row["RevisionNumber"].ToString(), out RevisionNumber);
weighment.RevisionNumber = RevisionNumber;
Weighments.Add(weighment);
}
}
}
return(Weighments);
}
public static Weighment GetDetailsForDuplicateSecondWeight2(string Vehicle)
{
Weighment weighment = new Weighment();
using (SQLiteHelper SQLite = new SQLiteHelper())
{
DataTable tblWeighment = SQLite.Select("SELECT w.* FROM Weighment as w Where w.ReferenceNumber ='" + Vehicle + "'");
if (tblWeighment.Rows.Count > 0)
{
foreach (DataRow row in tblWeighment.Rows)
{
weighment.TicketNumber = Convert.ToInt32(row["TicketNumber"]);
int Id = 0;
int.TryParse(row["Id"].ToString(), out Id);
weighment.Id = Id;
weighment.ReferenceNumber = row["ReferenceNumber"].ToString();
weighment.SealNo = row["SealNo"].ToString();
weighment.BiltyNo = row["BiltyNo"].ToString();
weighment.ContainerNo = row["ContainerNo"].ToString();
weighment.DriverName = row["DriverName"].ToString();
weighment.NoOfBags = row["NoOfBags"].ToString();
weighment.ClientId = row["ClientId"].ToString();
int revisionNumberId = 0;
int.TryParse(row["RevisionNumber"].ToString(), out revisionNumberId);
weighment.RevisionNumber = revisionNumberId;
DateTime ticketDate = DateTime.Now;
DateTime.TryParse(row["TicketDate"].ToString(), out ticketDate);
weighment.TicketDate = ticketDate;
weighment.ProductName = row["ProductName"].ToString();
DateTime firstDate = DateTime.Now;
DateTime.TryParse(row[6].ToString(), out firstDate);
weighment.FirstDateTime = firstDate;
double firstWeight = 0;
double.TryParse(row["FirstWeight"].ToString(), out firstWeight);
weighment.FirstWeight = firstWeight;
weighment.FirstType = row["FirstType"].ToString();
double NetWeight = 0;
double.TryParse(row["Weight"].ToString(), out NetWeight);
weighment.Weight = NetWeight;
double secondWeight = 0;
double.TryParse(row["SecondWeight"].ToString(), out secondWeight);
weighment.SecondWeight = secondWeight;
weighment.SecondType = row["SecondType"].ToString();
DateTime secondDate = DateTime.Now;
DateTime.TryParse(row[6].ToString(), out secondDate);
weighment.FirstDateTime = secondDate;
double amount = 0;
double.TryParse(row["Amount"].ToString(), out amount);
weighment.Amount = amount;
weighment.BarCode = row["BarCode"].ToString();
weighment.From = row["From"].ToString();
weighment.To = row["To"].ToString();
double recAmount = 0;
double.TryParse(row["ReceivedAmount"].ToString(), out recAmount);
weighment.ReceivedAmount = recAmount;
}
}
}
return(weighment);
}
public static Weighment GetDetailsForDuplicateSecondWeight(int TicketNumber)
{
Weighment weighment = new Weighment();
using (SQLiteHelper SQLite = new SQLiteHelper())
{
//DataTable tblWeighment = SQLite.Select("SELECT *, cl.Name AS ClientName, pro.Name AS ProductName FROM Weighment as w INNER JOIN Client AS cl on cl.Id = w.ClientId INNER JOIN Product AS pro on pro.Id = w.ProductId Where w.TicketNumber =" + TicketNumber);
DataTable tblWeighment = SQLite.Select("SELECT * FROM Weighment as w Where w.TicketNumber =" + TicketNumber);
if (tblWeighment.Rows.Count > 0)
{
foreach (DataRow row in tblWeighment.Rows)
{
weighment.TicketNumber = TicketNumber;
int Id = 0;
int.TryParse(row["Id"].ToString(), out Id);
weighment.Id = Id;
weighment.ReferenceNumber = row["ReferenceNumber"].ToString();
weighment.SealNo = row["SealNo"].ToString();
weighment.BiltyNo = row["BiltyNo"].ToString();
weighment.ContainerNo = row["ContainerNo"].ToString();
weighment.DriverName = row["DriverName"].ToString();
weighment.NoOfBags = row["NoOfBags"].ToString();
weighment.ClientId = row["ClientId"].ToString();
int revisionNumberId = 0;
int.TryParse(row["RevisionNumber"].ToString(), out revisionNumberId);
weighment.RevisionNumber = revisionNumberId;
DateTime ticketDate = DateTime.Now;
DateTime.TryParse(row["TicketDate"].ToString(), out ticketDate);
weighment.TicketDate = ticketDate;
weighment.ProductName = row["ProductName"].ToString();
DateTime firstDate = DateTime.Now;
DateTime.TryParse(row[6].ToString(), out firstDate);
weighment.FirstDateTime = firstDate;
double firstWeight = 0;
double.TryParse(row["FirstWeight"].ToString(), out firstWeight);
weighment.FirstWeight = firstWeight;
weighment.FirstType = row["FirstType"].ToString();
double NetWeight = 0;
double.TryParse(row["Weight"].ToString(), out NetWeight);
weighment.Weight = NetWeight;
double secondWeight = 0;
double.TryParse(row["SecondWeight"].ToString(), out secondWeight);
weighment.SecondWeight = secondWeight;
weighment.SecondType = row["SecondType"].ToString();
DateTime secondDate = DateTime.Now;
DateTime.TryParse(row[6].ToString(), out secondDate);
weighment.FirstDateTime = secondDate;
weighment.BarCode = row["BarCode"].ToString();
weighment.From = row["From"].ToString();
weighment.To = row["To"].ToString();
double amount = 0;
double.TryParse(row["Amount"].ToString(), out amount);
weighment.Amount = amount;
double receivedamount = 0;
double.TryParse(row["ReceivedAmount"].ToString(), out receivedamount);
weighment.ReceivedAmount = receivedamount;
}
}
}
return(weighment);
}
public static Weighment GetWeighmentDetails(int TicketNumber)
{
Weighment weighment = new Weighment();
using (SQLiteHelper SQLite = new SQLiteHelper())
{
DataTable tblWeighment = SQLite.Select("SELECT * FROM Weighment as w Where w.TicketNumber =" + TicketNumber);
if (tblWeighment.Rows.Count > 0)
{
foreach (DataRow row in tblWeighment.Rows)
{
weighment.TicketNumber = TicketNumber;
int Id = 0;
int.TryParse(row["Id"].ToString(), out Id);
weighment.Id = Id;
weighment.ReferenceNumber = row["ReferenceNumber"].ToString();
weighment.SealNo = row["SealNo"].ToString();
weighment.BiltyNo = row["BiltyNo"].ToString();
weighment.ContainerNo = row["ContainerNo"].ToString();
weighment.DriverName = row["DriverName"].ToString();
weighment.NoOfBags = row["NoOfBags"].ToString();
weighment.Remark = row["Remark"].ToString();
weighment.ClientId = row["ClientId"].ToString();
weighment.CreatedBy = row["CreatedBy"].ToString();
weighment.CreatedOn = Convert.ToDateTime(row["CreatedOn"]);
weighment.ModifiedBy = row["ModifiedBy"].ToString();
weighment.ModifiedOn = Convert.ToDateTime(row["Modifiedon"]);
int revisionNumberId = 0;
int.TryParse(row["RevisionNumber"].ToString(), out revisionNumberId);
weighment.RevisionNumber = revisionNumberId;
weighment.TicketDate = Convert.ToDateTime(row["TicketDate"].ToString());;
weighment.ProductName = row["ProductName"].ToString();
double firstWeight = 0;
double.TryParse(row["FirstWeight"].ToString(), out firstWeight);
weighment.FirstWeight = firstWeight;
weighment.FirstType = row["FirstType"].ToString();
double secondWeight = 0;
double.TryParse(row["SecondWeight"].ToString(), out secondWeight);
weighment.SecondWeight = secondWeight;
weighment.SecondType = row["SecondType"].ToString();
double NetWeight = 0;
double.TryParse(row["Weight"].ToString(), out NetWeight);
weighment.Weight = NetWeight;
weighment.MWeight = Convert.ToBoolean(row["MWeight"]);
weighment.BarCode = row["BarCode"].ToString();
weighment.From = row["From"].ToString();
weighment.To = row["To"].ToString();
double amount = 0;
double.TryParse(row["Amount"].ToString(), out amount);
weighment.Amount = amount;
double receivedamount = 0;
double.TryParse(row["ReceivedAmount"].ToString(), out receivedamount);
weighment.ReceivedAmount = receivedamount;
}
}
}
return(weighment);
}
