protected void btnAdd_Click(object sender, EventArgs e)
{
ModelUI objUI = new ModelUI();
MastersController objController = new MastersController();
string lblMsg = "";
int Code = Convert.ToInt16(txtCode.Text.Trim());
int GroupID = 0;
string strModelCode = "";
if (rdoAdd.Checked)
{
//strModelCode = txtModelCode.Text.Trim();
GroupID = SaveModelGroupName();
}
if (rdoAssign.Checked)
{
if (drpModelCode.SelectedIndex != 0)
{
// strModelCode = drpModelCode.SelectedItem.Text;
GroupID = Convert.ToInt32(drpModelCode.SelectedValue);
}
}
if (GroupID > 0)
{
string strDescription = txtDesc.Text.Trim();
int IsActive = 0;
if (chkActive.Checked)
{
IsActive = 1;
}
else
{
IsActive = 0;
}
int InReport = 0;
if (chkReport.Checked)
{
InReport = 1;
}
objUI.Code = Code;
objUI.GroupID = GroupID;
objUI.Description = strDescription;
objUI.IsActive = IsActive;
objUI.InReport = InReport;
objUI.IsGroup = 1;
string Date = objDate.ConvertDateFormat(CalstartDate.Value);
if (Date == "")
{
objUI.EffectDate = Convert.ToDateTime("1/1/1900");
}
else
{
objUI.EffectDate = Convert.ToDateTime(Date);
}
objUI.StatusID = Convert.ToInt32(hdnStatusID.Value);
try
{
objController.AddProduct(objUI, null);
Response.Redirect(strProjectName+"/View/Forms/Master/ModelDefault.aspx");
}
catch (Exception ex)
{
string strMessage = ex.Message;
if (strMessage.Contains("Cannot insert duplicate"))
{
lblMsg = "Cannot insert duplicate value, Please check the code";
string strjscript = "<script language='javascript'>";
strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + lblMsg + "' );";
strjscript += "</script" + ">";
Literal1.Text = strjscript;
//lblMessage.Text = "Cannot insert duplicate value, Please check the code";
}
else
{
lblMsg = "Record could not be added successfully";
string strjscript = "<script language='javascript'>";
strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + lblMsg + "' );";
strjscript += "</script" + ">";
Literal1.Text = strjscript;
//lblMessage.Text = "Record could not be added successfully";
}
}
}
}
/***********************************Function to Save Item File into Sql Server 2000 using Bulk Copy Method***********************************/
public string SaveItem(DataTable dt)
{
string lblMessage = "";
MastersController objCont = new MastersController();
string sConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["connectionString"].ToString();
int Status = 0;
try
{
string strDelete = "Delete from ItemTemp";
objController.ExecuteQuery(strDelete);
SqlConnection sqlconn = new SqlConnection(sConnectionString);
sqlconn.Open();
SqlBulkCopy bulkCopy = new SqlBulkCopy(sqlconn);
bulkCopy.DestinationTableName = "ItemTemp";
bulkCopy.WriteToServer(dt);
Status = objCont.SaveItemData();
if (Status == 1)
{
//Ask User if the duplicates are to be replaced
//if Yes then delete
Page.RegisterStartupScript("OnBlock", "<script language='javascript'>getStatus('item');</script>");
Session.Add("dtitem", dt);
}
else
{
string strItemException = "Declare @cnt int exec usp_AcrBulkDataInsert @cnt out";
objController.ExecuteQuery(strItemException);
lblMessage = "File Item saved successfully";
}
}
catch(Exception ex)
{
string strMessage = ex.Message.ToString();
if (strMessage.Contains("Cannot insert duplicate key in object"))
{
lblMessage = "Cannot insert duplicate values";
}
else
{
lblMessage = "Excel file is not in valid format";
}
//"File Item could not be saved successfully";
}
return lblMessage;
}
public void UpdateModel(object sender, EventArgs e)
{
MastersController objController = new MastersController();
ModelUI objUI = new ModelUI();
int Code = 0;
string strModelCode = "";
int GroupID = 0;
int index = Convert.ToInt16(hdnIndex.Value);
// string strQuery = "";
int ID = 0;
//int ID = Convert.ToInt32(((HiddenField)grdModelException.Rows[index].FindControl("hdnID")).Value);
string strCode = ((Label)grdModelException.Rows[index].FindControl("lblCode")).Text;
if (strCode == "")
{
Code = 0;
}
else
{
Code = Convert.ToInt16(strCode);
}
int selected = ((RadioButtonList)grdModelException.Rows[index].FindControl("rdoMode")).SelectedIndex;
if (selected == 0)
{
strModelCode = ((DropDownList)grdModelException.Rows[index].FindControl("drpModel")).SelectedItem.Text;
GroupID = Convert.ToInt16(((DropDownList)grdModelException.Rows[index].FindControl("drpModel")).SelectedValue);
}
else if (selected == 1)
{
strModelCode = ((TextBox)grdModelException.Rows[index].FindControl("txtModel")).Text;
}
objUI.Code = Code;
objUI.ModelCode = strModelCode;
objUI.GroupID = GroupID;
string strMessage = "";
//strQuery = "Insert into Model (Code,Model_Code) values (" + Code + ",'" + strModelCode + "')";
try
{
objController.SaveModel(objUI, ID);
}
catch
{}
try
{
string strAcrQuery = "Select * from AcrTemp where IsModelEx=0 and IsItemEx=0 and IsCulpritEx=0 and IsCVoiceEx=0 and IsDefectEx=0";
DataTable dtAcr = objQueryController.ExecuteQuery(strAcrQuery);
if (dtAcr != null)
{
SaveAcr(dtAcr);
string strDeleteAcrQuery = "Delete from AcrTemp where IsModelEx=0 and IsItemEx=0 and IsCulpritEx=0 and IsCVoiceEx=0 and IsDefectEx=0";
objQueryController.ExecuteQuery(strDeleteAcrQuery);
}
string strProductionQuery = "Select * from ProductionTemp where IsModelEx=0";
DataTable dtProd = objQueryController.ExecuteQuery(strProductionQuery);
if (dtProd != null)
{
SaveProduction(dtProd);
string strDeleteProdQuery = "Delete from ProductionTemp where IsModelEx=0";
objQueryController.ExecuteQuery(strDeleteProdQuery);
}
BindGrid();
strMessage = "Records Updated Successfully";
}
catch
{
strMessage = "Records could not be Updated Successfully";
}
string strjscript = "<script language='javascript'>";
strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + strMessage + "' );";
strjscript += "</script" + ">";
Literal1.Text = strjscript;
}
protected void btnAdd_Click(object sender, EventArgs e)
{
CVoiceUI objUI = new CVoiceUI();
MastersController objController = new MastersController();
string lblMsg = "";
int GroupID = 0;
int CVoiceCode = Convert.ToInt32(txtCVoiceCode.Text.Trim());
if (rdoAdd.Checked)
{
GroupID = SaveCVoiceGroup();
}
if (rdoAssign.Checked)
{
if (drpCVoiceGroup.SelectedIndex != 0)
{
GroupID = Convert.ToInt32(drpCVoiceGroup.SelectedValue);
}
}
if (GroupID > 0)
{
string strDescription = txtDesc.Text.Trim();
int IsActive = 0;
if (chkActive.Checked)
{
IsActive = 1;
}
else
{
IsActive = 0;
}
int InReport = 0;
if (chkReport.Checked)
{
InReport = 1;
}
else
{
InReport = 0;
}
// string strDate = getDate(strCalDate);
objUI.CVoiceCode = CVoiceCode;
objUI.GroupID = GroupID;
objUI.Description = strDescription;
objUI.IsActive = IsActive;
objUI.InReport = InReport;
objUI.IsGroup = 1;
//string DateTimeAppointment = Convert.ToString(CalstartDate.SelectedDate);
string Date = objDate.ConvertDateFormat(CalstartDate.Value);
if (Date == "")
{
objUI.EffectDate = Convert.ToDateTime("1/1/1900");
}
else
{
objUI.EffectDate = Convert.ToDateTime(Date);
}
objUI.StatusID = Convert.ToInt32(hdnStatusID.Value);
//string strQuery = "Insert into Culprit (Code,Description,IsActive,InReport,EffectDate) values (" + CulpritCode + ",'" + strDescription + "'," + IsActive + "," + InReport + ",'" + strDate + "')";
try
{
objController.AddCVoice(objUI, null);
Response.Redirect(strProjectName+"/View/Forms/Master/CustumerVoiceDefault.aspx");
}
catch (Exception ex)
{
string strMessage = ex.Message;
if (strMessage.Contains("Cannot insert duplicate"))
{
lblMsg = "Cannot insert duplicate value, Please check the culprit code";
string strjscript = "<script language='javascript'>";
strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + lblMsg + "' );";
strjscript += "</script" + ">";
Literal1.Text = strjscript;
// lblMessage.Text = "Cannot insert duplicate value, Please check the culprit code";
}
else
{
lblMsg = "Record could not be added successfully";
string strjscript = "<script language='javascript'>";
strjscript += " setMessageText('ctl00_ContentPlaceHolder1_lblMessage','" + lblMsg + "' );";
strjscript += "</script" + ">";
Literal1.Text = strjscript;
//lblMessage.Text = "Record could not be added successfully";
}
}
}
}
