private void butSua_Click(object sender, EventArgs e)
{
try
{
dgTyLe.Enabled = true;
enableButton(false);
ReadPercent item = (ReadPercent)cboTentyle.SelectedItem;
idReadPercent = item.Id;
}
catch (Exception ex)
{
throw ex;
}
}
public int ThemOBJ(ReadPercent readPercent, List <ReadPercent> listReadPercentItem)
{
int result = 0;
SqlConnection con = dbclass.taoketnoi();
SqlCommand cmd = con.CreateCommand();
SqlTransaction transaction;
transaction = con.BeginTransaction("Transaction");
try
{
cmd.Connection = con;
cmd.Transaction = transaction;
string sqlInsert = "insert into ReadPercent (Name, PercentFrom, PercentTo, CountRepeat, Sound, IdParent) values(N'" + readPercent.Name + "', " + readPercent.PercentFrom + "," + readPercent.PercentTo + "," + readPercent.CountRepeat + ",'" + readPercent.Sound + "', '0')";
cmd.CommandText = sqlInsert;
int insertResult = cmd.ExecuteNonQuery();
if (insertResult == 1)
{
int parentId = FindFinalId();
if (parentId != 0 && listReadPercentItem != null && listReadPercentItem.Count > 0)
{
foreach (var item in listReadPercentItem)
{
cmd.CommandText = "insert into ReadPercent (Name, PercentFrom, PercentTo, CountRepeat, Sound, IdParent) values(N'" + item.Name + "', " + item.PercentFrom + "," + item.PercentTo + "," + item.CountRepeat + ",'" + item.Sound + "', '" + parentId + "')";
cmd.ExecuteNonQuery();
}
}
}
transaction.Commit();
result = 1;
}
catch (Exception ex)
{
try
{
transaction.Rollback();
throw ex;
}
catch (Exception ex2)
{
throw ex2;
}
}
return(result);
}
public ResponseBase Update(int Id, List <ReadPercent> items)
{
var result = new ResponseBase();
try
{
db = new PMSEntities();
var olds = db.ReadPercents.Where(x => !x.IsDeleted && x.IdParent != null && x.IdParent.Value == Id);
if (olds != null && olds.Count() > 0)
{
foreach (var item in olds)
{
item.IsDeleted = true;
}
}
if (items != null && items.Count > 0)
{
ReadPercent subItem;
foreach (var itemObj in items)
{
subItem = new ReadPercent();
Parse.CopyObject(itemObj, ref subItem);
subItem.IsDeleted = false;
subItem.IdParent = Id;
db.ReadPercents.Add(subItem);
}
}
db.SaveChanges();
result.IsSuccess = true;
result.Messages.Add(new Message()
{
Title = "Thông Báo", msg = "Lưu thành công."
});
}
catch (Exception ex)
{
}
return(result);
}
public ResponseBase Insert(ReadPercent obj, List <ReadPercent> items)
{
var result = new ResponseBase();
try
{
db = new PMSEntities();
ReadPercent newObj;
newObj = new ReadPercent();
Parse.CopyObject(obj, ref newObj);
obj.IsDeleted = false;
db.ReadPercents.Add(obj);
db.SaveChanges();
if (items != null && items.Count > 0)
{
ReadPercent subItem;
foreach (var itemObj in items)
{
subItem = new ReadPercent();
Parse.CopyObject(itemObj, ref subItem);
subItem.IsDeleted = false;
subItem.IdParent = obj.Id;
db.ReadPercents.Add(subItem);
}
}
db.SaveChanges();
result.IsSuccess = true;
result.Messages.Add(new Message()
{
Title = "Thông Báo", msg = "Lưu thành công."
});
}
catch (Exception ex)
{
}
return(result);
}
private void butLuutyle_Click(object sender, EventArgs e)
{
if (!string.IsNullOrEmpty(cboTentyle.Text))
{
ResponseBase rs;
var obj = new ReadPercent()
{
Id = idReadPercent,
Name = cboTentyle.Text,
PercentFrom = 0,
PercentTo = 0,
CountRepeat = 0
};
List <ReadPercent> listReadPercent = new List <ReadPercent>();
if (dgTyLe.Rows.Count > 0)
{
ReadPercent rp;
for (int i = 0; i < dgTyLe.Rows.Count - 1; i++)
{
rp = new ReadPercent();
DataGridViewRow row = dgTyLe.Rows[i];
if (row != null)
{
int percentFrom = 0;
if (row.Cells["dgPercentFrom"].Value != null)
{
int.TryParse(row.Cells["dgPercentFrom"].Value.ToString(), out percentFrom);
}
rp.PercentFrom = percentFrom;
int percentTo = 0;
if (row.Cells["dgPercentTo"].Value != null)
{
int.TryParse(row.Cells["dgPercentTo"].Value.ToString(), out percentTo);
}
rp.PercentTo = percentTo;
int countRepeat = 0;
if (row.Cells["dgCountRepeat"].Value != null)
{
int.TryParse(row.Cells["dgCountRepeat"].Value.ToString(), out countRepeat);
}
rp.CountRepeat = countRepeat;
string sound = string.Empty;
if (row.Cells["tsound"].Value != null)
{
sound = row.Cells["tsound"].Value.ToString();
}
rp.Sound = sound;
rp.IdParent = idReadPercent;
listReadPercent.Add(rp);
}
}
}
if (idReadPercent == 0)
{
// result = readpercentDAO.ThemOBJ(obj, listReadPercent);
rs = BLLReadPercent.Instance.Insert(obj, listReadPercent);
}
else
{
// result = readpercentDAO.SuaThongTinOBJ(idReadPercent, listReadPercent);
rs = BLLReadPercent.Instance.Update(idReadPercent, listReadPercent);
}
if (rs.IsSuccess)
{
enableButton(true);
dgTyLe.Enabled = false;
loadDSTyLe();
loadPhanCongTyLe();
idReadPercent = 0;
MessageBox.Show("Lưu thông tin thành công");
}
}
else
{
MessageBox.Show("Tên tỷ lệ không được để trống", "Lỗi thao tác", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
