public string ReadFabricInfoDesignName(string DesignCode)
{
LinkedList <Entities.FabricInfo> DesignName = new LinkedList <FabricInfo>();
con = new SqlConnection();
cmd = new SqlCommand();
con.ConnectionString = Connection;
con.Open();
cmd.Connection = con;
cmd.CommandText = string.Format("Select [Design Name] from FabricInfo where [design code]='{0}'", DesignCode);
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (!string.IsNullOrWhiteSpace(reader[0].ToString()))
{
FabricInfo f2 = new FabricInfo();
f2.DesignName = reader[0].ToString();
DesignName.AddLast(f2);
}
}
con.Close();
reader.Close();
FabricInfo[] f3 = DesignName.ToArray <FabricInfo>();
if (f3.Length == 0)
{
return(string.Empty);
}
else
{
return(f3[0].DesignName);
}
}
public void ReadFabricInfoDesignCode(DataGridViewComboBoxColumn d1)
{
LinkedList <Entities.FabricInfo> f1 = new LinkedList <FabricInfo>();
con = new SqlConnection();
cmd = new SqlCommand();
con.ConnectionString = Connection;
con.Open();
cmd.Connection = con;
cmd.CommandText = "Select [Design Code] from FabricInfo";
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
FabricInfo f2 = new FabricInfo();
f2.DesignCode = reader[0].ToString();
f1.AddLast(f2);
}
con.Close();
reader.Close();
FabricInfo[] f3 = f1.ToArray <FabricInfo>();
f1 = null;
for (int i = 0; i < f3.Length; i++)
{
if (!string.IsNullOrWhiteSpace(f3[i].DesignCode))
{
d1.Items.Add(f3[i].DesignCode);
}
}
}
public void ReadFabricInfo(ComboBox Color, ComboBox KameezFabric, ComboBox ShalwarFabric, ComboBox DupattaFabric)
{
LinkedList <Entities.FabricInfo> f1 = new LinkedList <FabricInfo>();
con.Open();
cmd.CommandText = "Select * from FabricInfo";
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
FabricInfo f2 = new FabricInfo(reader[1].ToString(), reader[0].ToString());
f1.AddLast(f2);
}
con.Close();
reader.Close();
FabricInfo[] f3 = f1.ToArray <FabricInfo>();
f1 = null;
for (int i = 0; i < f3.Length; i++)
{
if (!string.IsNullOrWhiteSpace(f3[i].FabricName))
{
KameezFabric.Items.Add(f3[i].FabricName);
ShalwarFabric.Items.Add(f3[i].FabricName);
DupattaFabric.Items.Add(f3[i].FabricName);
}
if (!String.IsNullOrWhiteSpace(f3[i].FabricColor))
{
Color.Items.Add(f3[i].FabricColor);
}
}
}
public void ReadFabricInfo(ListBox l1, ListBox l2, ListBox l3, ListBox l4)
{
LinkedList <Entities.FabricInfo> f1 = new LinkedList <FabricInfo>();
con.Open();
cmd.CommandText = "Select * from FabricInfo";
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
FabricInfo f2 = new FabricInfo(reader[1].ToString(), reader[0].ToString(), reader[2].ToString(), reader[3].ToString());
f1.AddLast(f2);
}
con.Close();
reader.Close();
FabricInfo[] f3 = f1.ToArray <FabricInfo>();
f1 = null;
for (int i = 0; i < f3.Length; i++)
{
if (!string.IsNullOrWhiteSpace(f3[i].FabricName))
{
l1.Items.Add(f3[i].FabricName);
}
if (!String.IsNullOrWhiteSpace(f3[i].FabricColor))
{
l2.Items.Add(f3[i].FabricColor);
}
if (!string.IsNullOrWhiteSpace(f3[i].Stitching_Type))
{
l3.Items.Add(f3[i].Stitching_Type);
}
if (!string.IsNullOrWhiteSpace(f3[i].DesignCode))
{
l4.Items.Add(f3[i].DesignCode);
}
}
info = new LinkedList <FabricInfo>();
}
public FabricInfo[] ReadFabricStitching()
{
LinkedList <Entities.FabricInfo> f1 = new LinkedList <FabricInfo>();
con.Open();
cmd.CommandText = "Select [Stitching Type] from FabricInfo";
cmd.ExecuteNonQuery();
reader = cmd.ExecuteReader();
while (reader.Read())
{
if (!string.IsNullOrWhiteSpace(reader[0].ToString()))
{
FabricInfo f2 = new FabricInfo();
f2.Stitching_Type = reader[0].ToString();
f1.AddLast(f2);
}
}
con.Close();
reader.Close();
FabricInfo[] f3 = f1.ToArray <FabricInfo>();
f1 = null;
return(f3);
}