public string ReturnTranTypeWise(string tablename, string columnname, string typename)
{
string gnstr1 = null;
string middleNoFormated = null;
string gnstr = typename.Substring(0, 3).ToUpper() + "-0000000001-" + DateTime.Now.Year.ToString();
DataTable gntb = GetAutoGenNo(typename);
if (gntb.Rows.Count > 0)
{
gnstr1 = Convert.ToString(gntb.Rows[0][0]);
Config_CommonDB cm = new DAC.Config_CommonDB();
DataTable tranNotb = cm.ReturnTranNo(tablename, columnname);
if (tranNotb.Rows.Count > 0 && tranNotb.Rows[0][0].ToString() != string.Empty)
{
gnstr1 = Convert.ToString(tranNotb.Rows[0][0]);
middleNoFormated = "000000000" + Convert.ToString(Convert.ToInt32(gnstr1) + 1);
gnstr = typename.Substring(0, 3).ToUpper() + "-" + middleNoFormated.Substring(middleNoFormated.Length - 10) + "-" + DateTime.Now.Year.ToString();
}
}
return(gnstr);
}
protected void btnGenerateRequisition_Click(object sender, EventArgs e)
{
// Config_CommonDB cm = new DAC.Config_CommonDB();
//string getTranNo=cm.ReturnTranTypeWise("inv_purchaserequitionmaster_tbl", "PurchaseRequitionID","Requisition");
// string getTranNo = cm.ReturnTranTypeWise("com_userinfo_tbl", "UserID", "Requisition");
int Userids = 0;
int Result = 0;
int cSupID = 0;
int pSupID = 0;
int i = 0;
foreach (GridViewRow row in gvPD_DashBoard.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
bool isChecked = row.Cells[0].Controls.OfType <CheckBox>().FirstOrDefault().Checked;
if (isChecked)
{
i++;
}
}
}
if (i > 0)
{
foreach (GridViewRow row in gvPD_DashBoard.Rows)
{
if (row.RowType == DataControlRowType.DataRow)
{
bool isChecked = row.Cells[0].Controls.OfType <CheckBox>().FirstOrDefault().Checked;
//int ID = Int32.Parse((row.FindControl("lblID") as Label).Text);
int SampleID = Int32.Parse((row.FindControl("lblSampleID") as Label).Text);
// string SampleName = (row.FindControl("lblSampleName") as TextBox).Text;
int ItemID = Int32.Parse((row.FindControl("lblItemID") as Label).Text);
// string ItemCode = (row.FindControl("lblItemCode") as Label).Text;
decimal Qty = Decimal.Parse((row.FindControl("lblQty") as Label).Text);
decimal SampleQty = Decimal.Parse((row.FindControl("lblSampleQty") as TextBox).Text);
decimal Amount = Decimal.Parse((row.FindControl("lblAmount") as Label).Text);
int Supplier = Int32.Parse((row.FindControl("ddlSupplier") as DropDownList).SelectedValue);
Userids = Convert.ToInt32(HttpContext.Current.Session["UserID"]);
int Material_ID = Int32.Parse((row.FindControl("lblWoven_Material_ID") as Label).Text);
cSupID = Supplier;
if (cSupID != pSupID)
{
Config_CommonDB cm = new DAC.Config_CommonDB();
string getTranNo = cm.ReturnTranTypeWise("inv_purchaserequitionmaster_tbl", "PurchaseRequitionID", "Requisition");
if (isChecked)
{
try
{
string constr = ConfigurationManager.ConnectionStrings["MaheenERPConnection2"].ConnectionString;
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(constr))
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "CALL InsertRequestion_masterDetails_pro(@_PurchaseRequitionNo,@_PurchaseRequitionDate,@_PreparedBy, @_Status, @_SupplierID, @_SampleID,@CommandID);";
cmd.Parameters.Add("@_PurchaseRequitionNo", MySql.Data.MySqlClient.MySqlDbType.String).Value = getTranNo;
cmd.Parameters.Add("@_PurchaseRequitionDate", MySql.Data.MySqlClient.MySqlDbType.Datetime).Value = System.DateTime.Now.Date;
cmd.Parameters.Add("@_PreparedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 61;
cmd.Parameters.Add("@_Status", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
cmd.Parameters.Add("@_SupplierID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = Supplier;
cmd.Parameters.Add("@_SampleID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = SampleID;
//cmd.Parameters.Add("@_ProductID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ItemID;
//cmd.Parameters.Add("@_RequisitionQTY", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Qty;
//cmd.Parameters.Add("@_Rate", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = SampleQty;
//cmd.Parameters.Add("@_Amount", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Amount;
cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 1;
conn.Open();
cmd.ExecuteNonQuery();
}
DataTable sa = Retrun_MaxID();
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(constr))
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "CALL InsertRequestion_Details_pro(@_PurchaseRequitionID,@_ProductID, @_RequisitionQTY, @_Rate, @_Status,@_PreparedBy,@_SupplierID,@_Amount,@CommandID);";
//cmd.Parameters.Add("@_PurchaseRequitionNo", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = getTranNo;
cmd.Parameters.Add("@_PurchaseRequitionID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = sa.Rows[0]["MasterlastID"].ToString();
cmd.Parameters.Add("@_ProductID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ItemID;
cmd.Parameters.Add("@_RequisitionQTY", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Qty;
cmd.Parameters.Add("@_Rate", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = SampleQty;
cmd.Parameters.Add("@_Status", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
cmd.Parameters.Add("@_PreparedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 61;
cmd.Parameters.Add("@_SupplierID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = Supplier;
cmd.Parameters.Add("@_Amount", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Amount;
cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 2;
conn.Open();
cmd.ExecuteNonQuery();
}
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(constr))
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "CALL material_requisition_status_Update_pro(@Material_ID);";
cmd.Parameters.Add("@Material_ID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = Material_ID;
conn.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
lblMsg.Text = "Please Enter Correct Information";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}
}
else
{
if (isChecked)
{
try
{
DataTable sa = Retrun_MaxID();
string constr = ConfigurationManager.ConnectionStrings["MaheenERPConnection2"].ConnectionString;
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(constr))
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "CALL InsertRequestion_Details_pro(@_PurchaseRequitionID,@_ProductID, @_RequisitionQTY, @_Rate, @_Status,@_PreparedBy,@_SupplierID,@_Amount,@CommandID);";
//cmd.Parameters.Add("@_PurchaseRequitionNo", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = getTranNo;
cmd.Parameters.Add("@_PurchaseRequitionID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = sa.Rows[0]["MasterlastID"].ToString();
cmd.Parameters.Add("@_ProductID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ItemID;
cmd.Parameters.Add("@_RequisitionQTY", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Qty;
cmd.Parameters.Add("@_Rate", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = SampleQty;
cmd.Parameters.Add("@_Status", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
cmd.Parameters.Add("@_PreparedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 61;
cmd.Parameters.Add("@_SupplierID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = Supplier;
cmd.Parameters.Add("@_Amount", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Amount;
cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 2;
conn.Open();
cmd.ExecuteNonQuery();
}
using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(constr))
{
MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
cmd.Connection = conn;
cmd.CommandText = "CALL material_requisition_status_Update_pro(@Material_ID);";
cmd.Parameters.Add("@Material_ID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = Material_ID;
conn.Open();
cmd.ExecuteNonQuery();
}
}
catch (Exception ex)
{
lblMsg.Text = "Please Enter Correct Information";
lblMsg.ForeColor = System.Drawing.Color.Red;
}
}
}
pSupID = Supplier;
//Config_CommonDB cm = new DAC.Config_CommonDB();
//string getTranNo = cm.ReturnTranTypeWise("inv_purchaserequitionmaster_tbl", "PurchaseRequitionID", "Requisition");
//if (isChecked)
//{
// try
// {
// string constr = ConfigurationManager.ConnectionStrings["MaheenERPConnection2"].ConnectionString;
// using (MySql.Data.MySqlClient.MySqlConnection conn = new MySql.Data.MySqlClient.MySqlConnection(constr))
// {
// MySql.Data.MySqlClient.MySqlCommand cmd = new MySql.Data.MySqlClient.MySqlCommand();
// cmd.Connection = conn;
// cmd.CommandText = "CALL InsertRequestion_masterDetails_pro(@_PurchaseRequitionNo,@_PurchaseRequitionDate,@_PreparedBy, @_Status, @_SupplierID, @_SampleID,@_ProductID,@_RequisitionQTY,@_Rate,@_Amount,@CommandID);";
// cmd.Parameters.Add("@_PurchaseRequitionNo", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = getTranNo;
// cmd.Parameters.Add("@_PurchaseRequitionDate", MySql.Data.MySqlClient.MySqlDbType.Datetime).Value = System.DateTime.Now.Date;
// cmd.Parameters.Add("@_PreparedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 61;
// cmd.Parameters.Add("@_Status", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
// cmd.Parameters.Add("@_SupplierID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = Supplier;
// cmd.Parameters.Add("@_SampleID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = SampleID;
// cmd.Parameters.Add("@_ProductID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ItemID;
// cmd.Parameters.Add("@_RequisitionQTY", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Qty;
// cmd.Parameters.Add("@_Rate", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = SampleQty;
// cmd.Parameters.Add("@_Amount", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = Amount;
// cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 1;
// conn.Open();
// cmd.ExecuteNonQuery();
// }
// }
// catch (Exception ex)
// {
// lblMsg.Text = "Please Enter Correct Information";
// lblMsg.ForeColor = System.Drawing.Color.Red;
// }
//}
}
}
}
else
{
lblMsg.Text = "Please Select Order Number!";
lblMsg.ForeColor = System.Drawing.Color.Red;
return;
}
lblMsg.Text = "Requisition Date Updated Successfully!";
lblMsg.ForeColor = System.Drawing.Color.Green;
//btnExit_Click(sender, e);
}
