public String GenerateNoSurat(int lastValue, EnumSurat type) { lastValue += 1; String nolString = ""; for (int i = lastValue.ToString().Trim().Length; i < 4; i++) nolString += "0"; switch (type) { case EnumSurat.RO: nolString += lastValue + "/VJP/RO/" + DateTime.Today.Year; break; case EnumSurat.LeadTime: nolString += lastValue + "/VJP/LT/" + DateTime.Today.Year; break; case EnumSurat.PenawaranHarga: nolString += lastValue + "/VJP/PH/" + DateTime.Today.Year; break; case EnumSurat.ShippingInstruction: nolString += lastValue + "/VJP/SI/" + DateTime.Today.Year; break; } return nolString; }
public List<Surat> ListSurat(EnumSurat type) { List<Surat> listSurat = null; try { using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString)) { Constant.VisitaJayaPerkasaApplication.anyConnection = false; con.Open(); Constant.VisitaJayaPerkasaApplication.anyConnection = true; String strType = ""; if (type == EnumSurat.LeadTime) strType = "LT"; else if (type == EnumSurat.PenawaranHarga) strType = "PH"; else if (type == EnumSurat.RO) strType = "RO"; else strType = "SI"; using (SqlCommand command = new SqlCommand( "Select No_Surat, Tgl, [Surat].Customer_id, [Surat].Supplier_id, customer_name From [Surat] left join [Supplier] " + "on [surat].supplier_id = [supplier].supplier_id Left Join [Customer] " + "on [Customer].customer_id = [Surat].customer_id Where No_Surat like '%" + strType + "%'", con)) { SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { Surat surat = new Surat(); surat.NoSurat = reader.GetString(0); surat.Tgl = reader.GetDateTime(1); if (!Utility.Utility.IsDBNull(reader.GetValue(2))) surat.CustomerID = Utility.Utility.ConvertToUUID(reader.GetValue(2).ToString()); if (!Utility.Utility.IsDBNull(reader.GetValue(3))) surat.SupplierID = Utility.Utility.ConvertToUUID(reader.GetValue(3).ToString()); if (!Utility.Utility.IsDBNull(reader.GetValue(4))) surat.CustomerName = reader.GetString(4); if (listSurat == null) listSurat = new List<Surat>(); listSurat.Add(surat); surat = null; } } } } catch (Exception e) { Logging.Error("SqlSuratRepository.cs - ListSurat() " + e.Message); } return listSurat; }
public Surat GetlastNoSurat(EnumSurat type) { Surat surat = null; try { using (SqlConnection con = new SqlConnection(VisitaJayaPerkasa.Constant.VisitaJayaPerkasaApplication.connectionString)) { Constant.VisitaJayaPerkasaApplication.anyConnection = false; con.Open(); Constant.VisitaJayaPerkasaApplication.anyConnection = true; String strType = ""; switch (type) { case EnumSurat.LeadTime: strType = "LT"; break; case EnumSurat.PenawaranHarga: strType = "PH"; break; case EnumSurat.RO: strType = "RO"; break; case EnumSurat.ShippingInstruction: strType = "SI"; break; } using (SqlCommand command = new SqlCommand( "Select Top 1 No_Surat, Tgl, Customer_id, Supplier_id From [Surat] Where No_Surat Like '%" + strType + "%' Order by No_Surat desc", con)) { SqlDataReader reader = command.ExecuteReader(); if (reader.Read()) { surat = new Surat(); surat.NoSurat = reader.GetString(0); surat.Tgl = reader.GetDateTime(1); if (!Utility.Utility.IsDBNull(reader.GetValue(2))) surat.CustomerID = Utility.Utility.ConvertToUUID(reader.GetValue(2).ToString()); if (!Utility.Utility.IsDBNull(reader.GetValue(3))) surat.SupplierID = Utility.Utility.ConvertToUUID(reader.GetValue(3).ToString()); } } } } catch (Exception e) { Logging.Error("SqlSuratRepository.cs - GetlastNoSurat() " + e.Message); } return surat; }