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