public void InsertValuse(string Contract_month_start, string Contract_month_end, string Contract_payment_term, string Contract_Delievery_term, string Contract_loom_size, string Contract_no_of_looms, string Contract_item_name, string Contract_description, string Contract_Rate_per_Mt, string Contract_Total_cost, string Contract_Remarks)
{
try
{
query = "insert into Contract1([Contract_month_start],[Contract_month_end],[Contract_payment_term],[Contract_Delievery_term],[Contract_loom_size],[Contract_no_of_looms],[Contract_item_name],[Contract_description],[Contract_Rate_per_Mtr],[Contract_Total_cost],[Contract_Remarks]) values('" + Contract_month_start + "','" + Contract_month_end + "','" + Contract_payment_term + "','" + Contract_Delievery_term + "','" + Contract_loom_size + "'," + Contract_no_of_looms + ",'" + Contract_item_name + "','" + Contract_description + "'," + Contract_Rate_per_Mt + "," + Contract_Total_cost + ",'" + Contract_Remarks + "')";
sql.Insert_Update_Delete(query);
MessageBox.Show("Added Successfully");
}
catch (Exception ex)
{
MessageBox.Show("wrong transaction");
}
}
private void button1_Click(object sender, EventArgs e)
{
string filepath = ofd.FileName;
string query = "insert into item_GreyCloth (IGC_brand,IGC_image) values ('" + textBox1.Text + "','" + filepath + "')";
sql.Insert_Update_Delete(query);
}
public void InsertValuse(string YR_Brand, string YR_Bags_Rcvd, string YR_Date_Rcvd, string YR_Description, string YR_Status, string YR_Count, int managerID, int contractID)
{
try
{
query = "insert into Yarn_Receipt(YR_Date,YR_Brand,YR_Bags_Recvd,YR_Date_Recvd,YR_Description,YR_Status,YR_Count,Manager_ID,Contract_ID) values (getdate(),'" + YR_Brand + "','" + YR_Bags_Rcvd + "','" + YR_Date_Rcvd + "','" + YR_Description + "','" + YR_Status + "','" + YR_Count + "'," + managerID + "," + contractID + ")";
sql.Insert_Update_Delete(query);
}
catch (Exception ex)
{
}
}
public void InsertValue(string PL_Date, string PL_Party, string PL_Quality, string PL_Total_Mtr, string PL_TotalPeice, string PL_Vehicle_no, string PL_Status, string Manager_ID, string Contract_ID)
{
try
{
query = "insert into PackingList ([PL_Date],[PL_Party],[PL_Quality],[PL_Total_Mtr],[PL_TotalPeice],[PL_Vehicle_no],[PL_Status],[Manager_ID],[Contract_ID]) values " +
"(" + PL_Date + ",'" + PL_Party + "','" + PL_Quality + "'," + PL_Total_Mtr + "," + PL_TotalPeice + ",'" + PL_Vehicle_no + "','" + PL_Status + "'," + Manager_ID + "," + Contract_ID + ")";
sql.Insert_Update_Delete(query);
}
catch (Exception ex)
{
}
}
public void InsertValues(string I_Date, string I_Serial_No, string I_total_Amount, string I_Contract_No, string I_Description, string Manager_ID, string I_Status, string I_TotalMeter, string Buyer_ID, string Contract_ID)
{
try
{
query = "insert into Invoice ([I_Date],[I_Serial_No],[I_total_Amount],[I_Contract_No],[I_Description],[Manager_ID],[I_Status],[I_TotalMeter],[Buyer_ID],[Contract_ID])" +
"values ('" + I_Date + "','" + I_Serial_No + "'," + I_total_Amount + ",'" + I_Contract_No + "','" + I_Description + "'," + Manager_ID + ",'" + I_Status + "'," + I_TotalMeter + "," + Buyer_ID + "," + Contract_ID + ")";
sql.Insert_Update_Delete(query);
}
catch (Exception ex)
{
}
}