internal int UpdateData(LC_YarnDetermination aLC_YarnDetermination, int yarnDeterminationId)
{
try
{
LC_YarnDetermination LC_YarnDetermination = _Context.LC_YarnDetermination.First(x => x.Id == yarnDeterminationId);
LC_YarnDetermination.FebricNatureId = aLC_YarnDetermination.FebricNatureId;
LC_YarnDetermination.ColorRangeId = aLC_YarnDetermination.ColorRangeId;
LC_YarnDetermination.ConstructionId = aLC_YarnDetermination.ConstructionId;
LC_YarnDetermination.GSM = aLC_YarnDetermination.GSM;
LC_YarnDetermination.CompositionId = aLC_YarnDetermination.CompositionId;
LC_YarnDetermination.Percentage = aLC_YarnDetermination.Percentage;
LC_YarnDetermination.YarnCountId = aLC_YarnDetermination.YarnCountId;
LC_YarnDetermination.YarnCountTypeId = aLC_YarnDetermination.YarnCountTypeId;
LC_YarnDetermination.StichLength = aLC_YarnDetermination.StichLength;
LC_YarnDetermination.ProcessLoss = aLC_YarnDetermination.ProcessLoss;
LC_YarnDetermination.EditUser = aLC_YarnDetermination.EditUser;
LC_YarnDetermination.EditDate = aLC_YarnDetermination.EditDate;
LC_YarnDetermination.OCode = aLC_YarnDetermination.OCode;
_Context.SaveChanges();
return(1);
}
catch (Exception)
{
throw;
}
}
internal int SaveDataOriginal(LC_YarnDetermination aLC_YarnDetermination)
{
try
{
_Context.LC_YarnDetermination.AddObject(aLC_YarnDetermination);
_Context.SaveChanges();
return(1);
}
catch (Exception ex)
{
throw ex;
}
}
internal int SaveDataOriginal(LC_YarnDetermination aLC_YarnDetermination)
{
return(aYarnCountDeterminationDAL.SaveDataOriginal(aLC_YarnDetermination));
}
internal int UpdateData(LC_YarnDetermination aLC_YarnDetermination, int yarnDeterminationId)
{
return(aYarnCountDeterminationDAL.UpdateData(aLC_YarnDetermination, yarnDeterminationId));
}
protected void confirmButton_Click(object sender, EventArgs e)
{
int uniqueId = GenerateUniqueId();
string ocode = ((SessionUser)Session["SessionUser"]).OCode;
Guid userIdEccess = ((SessionUser)Session["SessionUser"]).UserId;
List <YarnDeterminationRepo> dataList = aYarnCountDeterminationBLL.LoadDataForGrid(ocode, userIdEccess);
try
{
foreach (YarnDeterminationRepo aYarnDeterminationRepo in dataList)
{
LC_YarnDetermination aLC_YarnDetermination = new LC_YarnDetermination();
aLC_YarnDetermination.FebricNatureId = aYarnDeterminationRepo.FebricNatureId;
aLC_YarnDetermination.ColorRangeId = aYarnDeterminationRepo.ColorRangeId;
aLC_YarnDetermination.ConstructionId = aYarnDeterminationRepo.ConstructionId;
aLC_YarnDetermination.ProductId = aYarnDeterminationRepo.ProductId;
aLC_YarnDetermination.GSM = aYarnDeterminationRepo.GSM;
aLC_YarnDetermination.CompositionId = aYarnDeterminationRepo.CompositionId;
aLC_YarnDetermination.Percentage = aYarnDeterminationRepo.Percentage;
aLC_YarnDetermination.Price = aYarnDeterminationRepo.Price;
aLC_YarnDetermination.StichLength = aYarnDeterminationRepo.StichLength;
aLC_YarnDetermination.ProcessLoss = aYarnDeterminationRepo.ProcessLoss;
aLC_YarnDetermination.UniqueId = uniqueId;
aLC_YarnDetermination.CreateUser = ((SessionUser)Session["SessionUser"]).UserId;
aLC_YarnDetermination.CreateDate = DateTime.Now;
aLC_YarnDetermination.OCode = ((SessionUser)Session["SessionUser"]).OCode;
aYarnCountDeterminationBLL.SaveDataOriginal(aLC_YarnDetermination);
}
foreach (YarnDeterminationRepo aYarnDeterminationRepo in dataList)
{
int tempEntryId = aYarnDeterminationRepo.YarnDeterminationId;
aYarnCountDeterminationBLL.DeleteDataFromTemp(tempEntryId);
}
LC_DeterminationCost aLC_DeterminationCost = new LC_DeterminationCost();
aLC_DeterminationCost.ConstructionFinishFebric = Convert.ToDecimal(constructionFinishFebricTextBox.Text);
aLC_DeterminationCost.KnitingCost = Convert.ToInt32(kinitingCostTextBox.Text);
aLC_DeterminationCost.DryingCostOption = dryingCostDropDownList.Text;
aLC_DeterminationCost.DryingCost = Convert.ToInt32(dryingCostTextBox.Text);
aLC_DeterminationCost.TotalCost = Convert.ToDecimal(totalTextBox.Text);
aLC_DeterminationCost.UniqueId = uniqueId;
aLC_DeterminationCost.CreateUser = ((SessionUser)Session["SessionUser"]).UserId;
aLC_DeterminationCost.CreateDate = DateTime.Now;
aLC_DeterminationCost.OCode = ((SessionUser)Session["SessionUser"]).OCode;
int result = aYarnCountDeterminationBLL.SaveToDeterminationCost(aLC_DeterminationCost);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "SuccessAlert('Save Successfully!!')", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Not Save!!')", true); return;
}
}
catch (Exception ex)
{
throw ex;
}
fabNatureDropDownList.Enabled = true;
constructionDropDownList.Enabled = true;
colorRangeDropDownList.Enabled = true;
gSMTextBox.Enabled = true;
//countDropDownList.Text = "";
//typeDropDownList.Text = "";
//UMDropDownList.Text = "";
FillFabricNature();
FillConstruction();
FillComposition();
//FillYarnCount();
//FillYarnCountType();
FillColor();
gSMTextBox.Text = "";
percentageTextBox.Text = "";
priceTextBox.Text = "";
txtStichLength.Text = "";
txtProcessLoss.Text = "";
kinitingCostTextBox.Text = "";
dryingCostDropDownList.Text = "";
dryingCostTextBox.Text = "";
totalTextBox.Text = "";
LoadDataInGrid();
LoadDeterminationDataForLastGrid();
}
//--------------------------------------Add Functions Work Here----------------------------------------------------
protected void addButton_Click(object sender, EventArgs e)
{
try
{
//Find The Product Id From Inv_Product Table
int groupId = Convert.ToInt32(constructionDropDownList.SelectedValue.ToString());
string productName = "Yarn";
string brandName = countDropDownList.Text;
string type = typeDropDownList.Text;
int unitId = Convert.ToInt32(UMDropDownList.SelectedValue.ToString());
int productId = aYarnCountDeterminationBLL.GetProductId(groupId, productName, brandName, type, unitId);
if (productId != 0)
{
if (addButton.Text == "Add")
{
LC_YarnDeterminationTemp aLC_YarnDeterminationTemp = new LC_YarnDeterminationTemp();
aLC_YarnDeterminationTemp.FebricNatureId = Convert.ToInt32(fabNatureDropDownList.SelectedValue.ToString());
aLC_YarnDeterminationTemp.ColorRangeId = Convert.ToInt32(colorRangeDropDownList.SelectedValue.ToString());
aLC_YarnDeterminationTemp.ConstructionId = Convert.ToInt32(constructionDropDownList.SelectedValue.ToString());
aLC_YarnDeterminationTemp.ProductId = productId;
aLC_YarnDeterminationTemp.GSM = gSMTextBox.Text;
aLC_YarnDeterminationTemp.CompositionId = Convert.ToInt32(compositionDropDownList.SelectedValue.ToString());
aLC_YarnDeterminationTemp.Percentage = percentageTextBox.Text;
aLC_YarnDeterminationTemp.Price = Convert.ToDecimal(priceTextBox.Text);
aLC_YarnDeterminationTemp.StichLength = txtStichLength.Text;
aLC_YarnDeterminationTemp.ProcessLoss = txtProcessLoss.Text;
aLC_YarnDeterminationTemp.CreateUser = ((SessionUser)Session["SessionUser"]).UserId;
aLC_YarnDeterminationTemp.CreateDate = DateTime.Now;
aLC_YarnDeterminationTemp.OCode = ((SessionUser)Session["SessionUser"]).OCode;
int result = aYarnCountDeterminationBLL.SaveData(aLC_YarnDeterminationTemp);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "SuccessAlert('Save Successfully!!')", true);
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Not Save!!')", true);
}
fabNatureDropDownList.Enabled = false;
constructionDropDownList.Enabled = false;
colorRangeDropDownList.Enabled = false;
gSMTextBox.Enabled = false;
}
else if (addButton.Text == "Update")
{
LC_YarnDetermination aLC_YarnDetermination = new LC_YarnDetermination();
aLC_YarnDetermination.FebricNatureId = Convert.ToInt32(fabNatureDropDownList.SelectedValue.ToString());
aLC_YarnDetermination.ColorRangeId = Convert.ToInt32(colorRangeDropDownList.SelectedValue.ToString());
aLC_YarnDetermination.ConstructionId = Convert.ToInt32(constructionDropDownList.SelectedValue.ToString());
aLC_YarnDetermination.ProductId = productId;
aLC_YarnDetermination.GSM = gSMTextBox.Text;
aLC_YarnDetermination.CompositionId = Convert.ToInt32(compositionDropDownList.SelectedValue.ToString());
aLC_YarnDetermination.Percentage = percentageTextBox.Text;
aLC_YarnDetermination.Price = Convert.ToDecimal(priceTextBox.Text);
aLC_YarnDetermination.StichLength = txtStichLength.Text;
aLC_YarnDetermination.ProcessLoss = txtProcessLoss.Text;
aLC_YarnDetermination.EditUser = ((SessionUser)Session["SessionUser"]).UserId;
aLC_YarnDetermination.EditDate = DateTime.Now;
aLC_YarnDetermination.OCode = ((SessionUser)Session["SessionUser"]).OCode;
int yarnDeterminationId = Convert.ToInt32(yarnCountTypeIdHiddenField.Value);
int result = aYarnCountDeterminationBLL.UpdateData(aLC_YarnDetermination, yarnDeterminationId);
if (result == 1)
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "SuccessAlert('Update Successfully!!')", true);
return;
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Not Update!!')", true); return;
}
}
}
else
{
ScriptManager.RegisterStartupScript(this, GetType(), "Popup", "notsuccessalert('Product Id Not Found!!')", true);
}
}
catch (Exception ex)
{
throw ex;
}
FillComposition();
LoadDataInGrid();
countDropDownList.DataSource = null;
typeDropDownList.DataSource = null;
UMDropDownList.DataSource = null;
percentageTextBox.Text = "";
priceTextBox.Text = "";
txtStichLength.Text = "";
txtProcessLoss.Text = "";
}
