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); }