public bool DeleteTpl(TemplateHeadModel model, string id)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"update tbl_template set deleted=1,Comp=@comp,UserName=@UserName,LastUpdate=@LastUpdate
where tplGUID=@Guid", cn);
cmd.Parameters.AddWithValue("@Guid", id);
cmd.Parameters.AddWithValue("comp", model.Comp);
cmd.Parameters.AddWithValue("UserName", model.UserName);
cmd.Parameters.AddWithValue("LastUpdate", model.LastUpdate);
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}
public bool InSertTpl(TemplateHeadModel model)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"Insert Into tbl_template (tplGUID,tplName,Comp,UserName,LastUpdate)
values(@tplGUID,@tplName,@Comp,@UserName,@LastUpdate)", cn);
cmd.Parameters.AddWithValue("@tplGUID", model.tplGUID);
cmd.Parameters.AddWithValue("@tplName", model.tplName);
cmd.Parameters.AddWithValue("@Comp", model.Comp);
cmd.Parameters.AddWithValue("@UserName", model.UserName);
cmd.Parameters.AddWithValue("@LastUpdate", model.LastUpdate);
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}
private void Btn_delete_Click(object sender, EventArgs e)
{
//if (!layerAccess.IsCanDelete("RONI"))
//{
// clsWin.WarningMessage("You dont have permition to access this form, please contact your administrator", "Access Denied");
// return;
//}
TemplateHeadModel um;
try
{
if (clsWin.QuestionMessage("Are you sure want to Delete this record?", "Confirm Delete"))
{
{
um = new TemplateHeadModel()
{
Comp = clsWin.GetComputerName(),
UserName = "******",//_frmMain.activeuser,
LastUpdate = DateTime.Now,
};
layertplHead.DeleteTpl(um, tplTemplateGUID);
}
clsWin.SuccessMessage("Template has been Delete", "Success");
tplTemplateGUID = "";
loadAllDataGroup();
getListDataTpl();
txt_Name.Text = "";
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var exceptionMessage = string.Concat(errorMessages);
clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
Btn_refresh.PerformClick();
}
}
public bool UpdatetTpl(TemplateHeadModel model, string id)
{
try
{
ExecuteCommand(cn =>
{
MySqlCommand cmd = new MySqlCommand(@"Update tbl_template set Comp=@Comp,UserName=@UserName,LastUpdate=@LastUpdate where tplGUID=@tplGUID", cn);
//string qry = @"Update tbl_template set Comp=@Comp,UserName=@UserName,LastUpdate=@LastUpdate where tplGUID=@tplGUID";
cmd.Parameters.AddWithValue("@tplGUID", id);
cmd.Parameters.AddWithValue("@Comp", model.Comp);
cmd.Parameters.AddWithValue("@UserName", model.UserName);
cmd.Parameters.AddWithValue("@LastUpdate", model.LastUpdate);
// qry = qry;
rst = cmd.ExecuteNonQuery();
});
if (rst == 1)
return true;
else
return false;
}
catch (Exception)
{
throw;
}
}
private void Btn_Save_Click(object sender, EventArgs e)
{
string usr = _frmMain.activeuser;
if (StatusEdit == false)
{
if (!validasiTextBox())
{
return;
}
if (layertplHead.GetValTpl(txt_Name.Text))
{
var exceptionMessage = "template already exist";
// clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
txt_Name.Focus();
return;
}
TemplateHeadModel TplHeader;
TemplateDetModel TplDet;
try
{
{
TplHeader = new TemplateHeadModel()
{
tplGUID = Guid.NewGuid().ToString(),
tplName = txt_Name.Text,
Comp = clsWin.GetComputerName(),
UserName = usr,
LastUpdate = DateTime.Now
};
layertplHead.InSertTpl(TplHeader);
Cursor.Current = Cursors.WaitCursor;
for (int i = 0; i <= dgViewGroup.RowCount - 1; i++)
{
if(int.Parse( dgViewGroup.Rows[i].Cells[3].Value.ToString())==1)
{
TplDet = new TemplateDetModel()
{
tplHDGUID=TplHeader.tplGUID,
pgGUID=dgViewGroup.Rows[i].Cells[0].Value.ToString()
};
layerTplDet.InSertTplDet(TplDet);
}
}
clsWin.SuccessMessage("Template has been saved", "Success");
tplTemplateGUID = "";
loadAllDataGroup();
getListDataTpl();
txt_Name.Text="";
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var exceptionMessage = string.Concat(errorMessages);
clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
}
}
else
{
if (!validasiTextBox())
{
return;
}
TemplateHeadModel TplHeader;
TemplateDetModel TplDet;
try
{
{
TplHeader = new TemplateHeadModel()
{
tplGUID = tplTemplateGUID,
tplName = txt_Name.Text,
Comp = clsWin.GetComputerName(),
UserName = usr,
LastUpdate = DateTime.Now
};
layertplHead.UpdatetTpl(TplHeader, tplTemplateGUID);
Cursor.Current = Cursors.WaitCursor;
layerTplDet.DeleteBefEdit(tplTemplateGUID);
for (int i = 0; i <= dgViewGroup.RowCount - 1; i++)
{
int val = dgViewGroup.Rows[i].Cells[3].Value.ToString() == "" ? 0 : 1;
if (val == 1)
{
TplDet = new TemplateDetModel()
{
tplHDGUID=tplTemplateGUID,
pgGUID=dgViewGroup.Rows[i].Cells[0].Value.ToString()
};
layerTplDet.InSertTplDet(TplDet);
//TplDet.tplHDGUID = TplHeader.tplGUID,
//TplDet.pgGUID = (dgViewGroup.Rows[i].Cells[0].Value.ToString())
}
}
clsWin.SuccessMessage("Template has been Edit", "Success");
tplTemplateGUID = "";
loadAllDataGroup();
getListDataTpl();
txt_Name.Text="";
}
}
catch (DbEntityValidationException ex)
{
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
var exceptionMessage = string.Concat(errorMessages);
clsWin.ClearWindowsObJect(panelEx1);
clsWin.ErrorMessage((exceptionMessage).ToString(), "Oops");
}
}
StatusEdit = false;
txt_Name.ReadOnly = true;
loadAllDataGroup();
}
