private void WeavingTypeList()
{
NPD_PFL_SPEC pfl = new NPD_PFL_SPEC();
ddlWeavingType.DataSource = pfl.SearchCommonTbl("WovevingStyle");
ddlWeavingType.DataTextField = "ListItem";
ddlWeavingType.DataValueField = "ID";
ddlWeavingType.DataBind();
}
public void WarpColor()
{
NPD_PFL_SPEC pfl = new NPD_PFL_SPEC();
txtColor.DataSource = pfl.SearchCommonTbl("Color");
txtColor.DataTextField = "ListItem";
txtColor.DataValueField = "ID";
txtColor.DataBind();
}
protected void lblDeletedetails_Click(object sender, EventArgs e)
{
GridViewRow gvRow = (GridViewRow)(sender as Control).Parent.Parent;
Label PurchaseRequisitionDetailsID = (Label)gvRow.FindControl("lblPurchaseRequisitionDetailsID1");
Label SupplierID = (Label)gvRow.FindControl("lblSupplierID1");
Label SampleID = (Label)gvRow.FindControl("lblSampleID");
Label ProductID = (Label)gvRow.FindControl("lblProductID1");
NPD_PFL_SPEC woven = new NPD_PFL_SPEC();
woven.DetailsRequestionGenerateStatusUpdate(Int32.Parse(PurchaseRequisitionDetailsID.Text), Int32.Parse(SupplierID.Text), Int32.Parse(SampleID.Text), Int32.Parse(ProductID.Text));
gvPurchaseRequitionID_DashBoard.DataSource = null;
gvPurchaseRequitionID_DashBoard.DataBind();
}
protected void btnEdit_Click(object sender, EventArgs e)
{
NPD_PFL_SPEC pfl = new NPD_PFL_SPEC();
try
{
pfl.InsertUpdateMaterials(Int32.Parse(Label1.Text), Int32.Parse(ddlSampleID.SelectedValue), Int32.Parse(ddlStoreItemID.SelectedValue), Decimal.Parse(txtQuanity.Text), Int32.Parse(ddlUnit.SelectedValue), txtMahenCode.Text, 68, Convert.ToDateTime(System.DateTime.Now), 0, 2);
}
catch (Exception ex)
{
throw ex;
}
Commom_GridLoad(0);
btnExit_Click(sender, e);
}
protected void btnEdit_Click(object sender, EventArgs e)
{
NPD_PFL_SPEC pfl = new NPD_PFL_SPEC();
try
{
pfl.InsertUpdatepfl_techonical(Int32.Parse(Label1.Text), Int32.Parse(ddlSampleID.SelectedValue), Decimal.Parse(txtOverallLength.Text), Decimal.Parse(txtOverallWidth.Text), Decimal.Parse(txtFinishedLength.Text), Decimal.Parse(txtFinishedWidth.Text), Int32.Parse(txtForntSideColor.Text), Int32.Parse(txtBackSideColor.Text), txtRibbonType.Text, Int32.Parse(txtRibbonColor.Text), Decimal.Parse(txtRibbonWidth.Text), Int32.Parse(txtEdgeQuality.Text), Int32.Parse(txtFaceQuality.Text), txtItemDescription.Text, Int32.Parse(ddlMachineID.SelectedValue), Int32.Parse(txtFirstHeatPlateTemp.Text), Int32.Parse(txtSecondHeatPlateTemp.Text), txtMachineSpeed.Text, txtFinishType.Text, txtFoldingType.Text, txtCuringTime.Text, txtCuiringTemparature.Text, txtItemAttributes.Text, txtKeyEntry1.Text,
txtKeyEntry2.Text, txtKeyEntry3.Text, txtKeyEntry4.Text, txtKeyEntry5.Text, txtKeyEntry6.Text, txtKeyEntry7.Text, txtKeyEntry8.Text, txtKeyEntry9.Text, txtKeyEntry10.Text, 68, Convert.ToDateTime(System.DateTime.Now), 0, 2);
}
catch (Exception ex)
{
throw ex;
}
Commom_GridLoad(0);
btnExit_Click(sender, e);
}
protected void btnSave_Click(object sender, EventArgs e)
{
NPD_PFL_SPEC pfl = new NPD_PFL_SPEC();
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 InsertUpdate_npd_pfl_materials_proc(@Pfl_Material_ID ,@SampleID ,@StoreItemID ,@Quanity,@Unit,@MahenCode ,@CreatedBy ,@CreationDate,@Status,@CommandID);";
// cmd.Parameters.Add("@Pfl_Material_ID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
// cmd.Parameters.Add("@SampleID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlSampleID.SelectedValue;
// cmd.Parameters.Add("@StoreItemID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlStoreItemID.SelectedValue;
// cmd.Parameters.Add("@Quanity", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtQuanity.Text;
// cmd.Parameters.Add("@Unit", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlUnit.SelectedValue;
// cmd.Parameters.Add("@MahenCode", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtMahenCode.Text;
// cmd.Parameters.Add("@CreatedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 68;
// cmd.Parameters.Add("@CreationDate", MySql.Data.MySqlClient.MySqlDbType.DateTime).Value = System.DateTime.Now.Date;
// cmd.Parameters.Add("@Status", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
// cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 1;
// conn.Open();
// cmd.ExecuteNonQuery();
//}
pfl.InsertUpdateMaterials(0, Int32.Parse(ddlSampleID.SelectedValue), Int32.Parse(ddlStoreItemID.SelectedValue), Decimal.Parse(txtQuanity.Text), Int32.Parse(ddlUnit.SelectedValue), txtMahenCode.Text, 68, Convert.ToDateTime(System.DateTime.Now), 0, 1);
}
catch (Exception ex)
{
throw ex;
}
Commom_GridLoad(0);
btnExit_Click(sender, e);
}
protected void btnEdit_Click(object sender, EventArgs e)
{
NPD_PFL_SPEC pfl = new NPD_PFL_SPEC();
try
{
pfl.InsertUpdate_Woven_techonical(Int32.Parse(Label1.Text), Int32.Parse(ddlSampleID.SelectedValue), Int32.Parse(txtColor.Text), Int32.Parse(ddlWeavingType.Text),
txtFileName.Text, Decimal.Parse(txtPick.Text), Decimal.Parse(txtCutter.Text), Decimal.Parse(txtLengthCuttoCut.Text), txtDamaskLengh.Text, txtFinishedlength.Text, Decimal.Parse(txtWidth.Text), Decimal.Parse(txtHuk.Text), Int32.Parse(ddlStracingInfo.SelectedValue),
Int32.Parse(ddlIronicInfo.SelectedValue), Int32.Parse(ddlUltrasonicCutting.SelectedValue), txtWash_Starch_Ironing_Time.Text, Decimal.Parse(txtPickWheel.Text), txtKeyEntry1.Text,
txtKeyEntry2.Text, txtKeyEntry3.Text, txtKeyEntry4.Text, txtKeyEntry5.Text, txtKeyEntry6.Text, txtKeyEntry7.Text, txtKeyEntry8.Text, txtKeyEntry9.Text, txtKeyEntry10.Text, 0, 68, Convert.ToDateTime(System.DateTime.Now), 2);
}
catch (Exception ex)
{
throw ex;
}
Commom_GridLoad(0);
btnExit_Click(sender, e);
}
protected void btnEdit_Click(object sender, EventArgs e)
{
NPD_PFL_SPEC pfl = new NPD_PFL_SPEC();
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 InsertUpdate_npd_woven_material_proc(@Woven_Material_ID, @SampleID, @StoreItemID, @MaheenCode, @Quanity, @Unit, @Color_Name, @Denier, @Pick_Yarnwise, @SuppilerID, @Batch_ID, @StatusID, @CreatedBy, @CreatedDate, @CommandID);";
cmd.Parameters.Add("@Woven_Material_ID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = Label1.Text;
cmd.Parameters.Add("@SampleID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlSampleID.SelectedValue;
cmd.Parameters.Add("@StoreItemID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlStoreItemID.SelectedValue;
cmd.Parameters.Add("@MaheenCode", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtMahenCode.Text;
cmd.Parameters.Add("@Quanity", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtQuanity.Text;
cmd.Parameters.Add("@Unit", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlUnit.SelectedValue;
cmd.Parameters.Add("@Color_Name", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtColorName.Text;
cmd.Parameters.Add("@Denier", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtDenier.Text;
cmd.Parameters.Add("@Pick_Yarnwise", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtPick_Yarnwise.Text;
cmd.Parameters.Add("@SuppilerID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlSupplerID.SelectedValue;
cmd.Parameters.Add("@Batch_ID", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtBatch.Text;
cmd.Parameters.Add("@StatusID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
cmd.Parameters.Add("@CreatedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 68;
cmd.Parameters.Add("@CreatedDate", MySql.Data.MySqlClient.MySqlDbType.DateTime).Value = System.DateTime.Now.Date;
cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 2;
conn.Open();
cmd.ExecuteNonQuery();
}
// pfl.InsertUpdateMaterials(0, Int32.Parse(ddlSampleID.SelectedValue), Int32.Parse(ddlStoreItemID.SelectedValue), Decimal.Parse( txtQuanity.Text), Int32.Parse(ddlUnit.SelectedValue), txtMahenCode.Text, 68, Convert.ToDateTime(System.DateTime.Now), 0, 1);
}
catch (Exception ex)
{
throw ex;
}
Commom_GridLoad(0);
btnExit_Click(sender, e);
}
protected void btnSave_Click(object sender, EventArgs e)
{
try
{
NPD_PFL_SPEC DB = new NPD_PFL_SPEC();
DataTable DuplicateDate1 = DB.DuplicateSampleName((txtSampleName.Text.Trim()));
if (DuplicateDate1.Rows[0][0].ToString() == "1")
{
Response.Write("<script>alert('This " + txtSampleName.Text + " Duplicate ');</script>");
return;
}
// (string inSampleName, int inBrandID, int inProgramID, decimal inLength, decimal inWidth, int inQuotedPrice)
DataTable DuplicateDate = DB.DuplicateDateTableWoven(Int32.Parse(ddBrand.SelectedValue), Int32.Parse(ddlProgram.SelectedValue), Decimal.Parse(txtLenghtmm.Text.Trim()), Decimal.Parse(txtwidthmm.Text.Trim()), Int32.Parse(txtQuotedPrice.Text.Trim()), txtImagepath.Text.Trim());
if (DuplicateDate.Rows[0][0].ToString() == "1")
{
Response.Write("<script>alert('Some Data All ready Sample create ');</script>");
return;
}
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 InsertUpdateWoven_GeneralSpec_Proc(@GSampleID,@SampleNo,@SampleName,@CustomerSampleName, @BrandID, @ProgramID, @ProductCategoryID,@ProductSubCategoryID, @ClientID, @CompanyID, @NPDExecutive, @Unit, @Length, @Width, @QuotedPrice, @ArtworkLocation_FileName, @Imagepath, @Cancel, @CreatedBy ,@CreationDate, @Status , @TotalNoOfColor , @ModifyBy, @ModifyDate, @CommandID);";
cmd.Parameters.Add("@GSampleID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
cmd.Parameters.Add("@SampleNo", MySql.Data.MySqlClient.MySqlDbType.String).Value = "";
cmd.Parameters.Add("@SampleName", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtSampleName.Text;
cmd.Parameters.Add("@CustomerSampleName", MySql.Data.MySqlClient.MySqlDbType.String).Value = "";
cmd.Parameters.Add("@BrandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddBrand.SelectedValue;
cmd.Parameters.Add("@ProgramID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlProgram.SelectedValue;
cmd.Parameters.Add("@ProductCategoryID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 1;
cmd.Parameters.Add("@ProductSubCategoryID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddSubCategory.SelectedValue;
cmd.Parameters.Add("@ClientID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddClient.SelectedValue;
cmd.Parameters.Add("@CompanyID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlCompany.SelectedValue;
cmd.Parameters.Add("@NPDExecutive", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddPDExecutive.SelectedValue;
cmd.Parameters.Add("@Unit", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlUnit.SelectedValue;
cmd.Parameters.Add("@Length", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtLenghtmm.Text;
cmd.Parameters.Add("@Width", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtwidthmm.Text;
cmd.Parameters.Add("@QuotedPrice", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtQuotedPrice.Text;
cmd.Parameters.Add("@ArtworkLocation_FileName", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtArtworkLocation.Text;
cmd.Parameters.Add("@Imagepath", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtImagepath.Text;
cmd.Parameters.Add("@Cancel", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlCancel.SelectedValue;
cmd.Parameters.Add("@CreatedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 68;
cmd.Parameters.Add("@CreationDate", MySql.Data.MySqlClient.MySqlDbType.Datetime).Value = System.DateTime.Now.Date;
cmd.Parameters.Add("@Status", MySql.Data.MySqlClient.MySqlDbType.String).Value = 0;
cmd.Parameters.Add("@TotalNoOfColor", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = txtTotalColor.Text;
cmd.Parameters.Add("@ModifyBy", MySql.Data.MySqlClient.MySqlDbType.String).Value = 68;
cmd.Parameters.Add("@ModifyDate", MySql.Data.MySqlClient.MySqlDbType.Datetime).Value = System.DateTime.Now.Date;
cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.String).Value = 1;
conn.Open();
cmd.ExecuteNonQuery();
}
DataTable sa = Retrun_SampleID(txtSampleName.Text);
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 InsertUpdateNpd_Woven_Spec(@woven_ID,@SampleID,@SampleName, @BrandID, @ProgramID, @ProductCategoryID,@ProductSubCategoryID, @ClientID, @CompanyID, @NPDExecutive, @Unit, @Length, @Width, @QuotedPrice, @ArtworkLocation_FileName, @Imagepath, @Cancel, @CreatedBy ,@CreationDate, @Status , @TotalNoOfColor , @ModifyBy, @ModifyDate, @CommandID);";
cmd.Parameters.Add("@woven_ID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 0;
cmd.Parameters.Add("@SampleID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = sa.Rows[0]["SampleID"].ToString();
cmd.Parameters.Add("@SampleName", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtSampleName.Text;
cmd.Parameters.Add("@BrandID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddBrand.SelectedValue;
cmd.Parameters.Add("@ProgramID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlProgram.SelectedValue;
cmd.Parameters.Add("@ProductCategoryID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 1;
cmd.Parameters.Add("@ProductSubCategoryID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddSubCategory.SelectedValue;
cmd.Parameters.Add("@ClientID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddClient.SelectedValue;
cmd.Parameters.Add("@CompanyID", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlCompany.SelectedValue;
cmd.Parameters.Add("@NPDExecutive", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddPDExecutive.SelectedValue;
cmd.Parameters.Add("@Unit", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlUnit.SelectedValue;
cmd.Parameters.Add("@Length", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtLenghtmm.Text;
cmd.Parameters.Add("@Width", MySql.Data.MySqlClient.MySqlDbType.Decimal).Value = txtwidthmm.Text;
cmd.Parameters.Add("@QuotedPrice", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtQuotedPrice.Text;
cmd.Parameters.Add("@ArtworkLocation_FileName", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtArtworkLocation.Text;
cmd.Parameters.Add("@Imagepath", MySql.Data.MySqlClient.MySqlDbType.String).Value = txtImagepath.Text;
cmd.Parameters.Add("@Cancel", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = ddlCancel.SelectedValue;
cmd.Parameters.Add("@CreatedBy", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = 68;
cmd.Parameters.Add("@CreationDate", MySql.Data.MySqlClient.MySqlDbType.Datetime).Value = System.DateTime.Now.Date;
cmd.Parameters.Add("@Status", MySql.Data.MySqlClient.MySqlDbType.String).Value = 0;
cmd.Parameters.Add("@TotalNoOfColor", MySql.Data.MySqlClient.MySqlDbType.Int32).Value = txtTotalColor.Text;
cmd.Parameters.Add("@ModifyBy", MySql.Data.MySqlClient.MySqlDbType.String).Value = 68;
cmd.Parameters.Add("@ModifyDate", MySql.Data.MySqlClient.MySqlDbType.Datetime).Value = System.DateTime.Now.Date;
cmd.Parameters.Add("@CommandID", MySql.Data.MySqlClient.MySqlDbType.String).Value = 1;
conn.Open();
cmd.ExecuteNonQuery();
}
}
catch (MySqlException ex)
{
Console.WriteLine("SQL Error" + ex.Message.ToString());
}
btnExit_Click(sender, e);
// Commom_GridLoad();
}
