public JsonResult Add(SuKienModel m)
{
ResponseBase res = new ResponseBase();
try
{
SuKien dt = new SuKien
{
Ten = m.Ten,
NoiDung = m.NoiDung,
DiaDiem = m.DiaDiem,
BatDau = DateTime.Parse(m.BatDau),
GhiChu = m.GhiChu
};
db.SuKiens.InsertOnSubmit(dt);
db.SubmitChanges();
res.Status = StatusID.Success;
res.Message = "Đã thêm sự kiện";
}
catch (Exception e)
{
res.Status = StatusID.InternalServer;
res.Message = e.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public JsonResult Add(DeXuatModel m)
{
ResponseBase res = new ResponseBase();
try
{
var ses = (UserSave)Session[Constant.USER_SESSION];
DeXuat dt = new DeXuat
{
IDDoanVien = m.IDDoanVien,
NoiDung = m.NoiDung,
NgayThang = DateTime.Parse(m.NgayThang),
Loai = 1,
TrangThai = 2,
NguoiDeXuat = ses.HoTen
};
db.DeXuats.InsertOnSubmit(dt);
db.SubmitChanges();
res.Status = StatusID.Success;
res.Message = "Đã thêm";
}
catch (Exception e)
{
res.Status = StatusID.InternalServer;
res.Message = e.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public bool action_update_status(int ID)
{
if (Session["username"] != null && !string.IsNullOrEmpty(Session["username"].ToString()))
{
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == ID select p).FirstOrDefault();
_quiz.Status = _quiz.Status == 0 ? 1 : 0;
sql.SubmitChanges();
return(true);
}
return(false);
}
private void get_insttalment()
{
for (int i = 0; i < gridView2.RowCount; i++)
{
Tb_Installment installment = new Tb_Installment();
installment.Canceled = false;
installment.is_deleted = false;
installment.is_Repayment = false;
installment.Repayment_Date = Convert.ToDateTime(gridView2.GetRowCellDisplayText(i, "Repayment_Date"));
installment.Amount = Convert.ToDecimal(gridView2.GetRowCellDisplayText(i, "Amount"));
installment.v_id = Convert.ToInt64(Voucher_Serial.Text);
linq.Tb_Installments.InsertOnSubmit(installment);
linq.SubmitChanges();
}
}
protected void btnDelete_Click1(object sender, EventArgs e)
{
try
{
string del_list = hdfCheck.Value;
string[] sp_list = del_list.Split(new char[] { ';' }, StringSplitOptions.RemoveEmptyEntries);
List <tblQuiz> arrDe = new List <tblQuiz>();
for (int i = 0; i < sp_list.Length; i++)
{
tblQuiz _quiz = (from p in sql.tblQuizs where p.ID == Convert.ToInt32(sp_list[i]) select p).FirstOrDefault();
_quiz.Status = -1;
//try
//{
// DataTable db = news.GetNewsByID(sp_list[i]);
// bool kt = File.Exists(Server.MapPath("~/Images/news/") + db.Rows[0]["IMAGE"]);
// if (kt)
// File.Delete(Server.MapPath("~/Images/news/") + db.Rows[0]["IMAGE"]);
//}
//catch (Exception)
//{
// throw;
//}
//news.tblNewsDelete(int.Parse(sp_list[i]));
}
sql.SubmitChanges();
Response.Redirect(Request.RawUrl);
}
catch (Exception ex)
{
divMessage.InnerHtml = O2S_Message.Error("Cảnh Báo", "Phát hiện lỗi! " + ex.Message);
}
}
public static void EndMissionDate()
{
var bank = new LinqDataContext();
var query = from p in bank.sarbazs
where p.مدت_ماموریت_ماه_ != null
select p;
foreach (var items in query)
{
PersianCalendar pcalender = new PersianCalendar();
DateTime date = pcalender.ToDateTime(Convert.ToDateTime(items.تاریخ_اعزام).Year,
Convert.ToDateTime(items.تاریخ_اعزام).Month,
Convert.ToDateTime(items.تاریخ_اعزام).Day, 0, 0, 0, 0, 0
);
var x = items.مدت_ماموریت_ماه_;
if (x == "" || x == null)
{
x = "0";
}
DateTime date_EndMission = date.AddMonths(Convert.ToInt32(x));
items.تاریخ_اتمام_ماموریت = pcalender.GetYear(date_EndMission) + "/" +
pcalender.GetMonth(date_EndMission) + "/" +
pcalender.GetDayOfMonth(date_EndMission);
}
// return date_EndMission;
bank.SubmitChanges();
}
public JsonResult DangKySuKien(int IDSuKien)
{
var ses = (DoanVienSave)Session[Constant.CUS_SESSION];
var lst = (from a in db.DangKies
where a.IDSuKien == IDSuKien && a.IDDoanVien == ses.ID
select new DoanVienModel
{
HoTen = a.DoanVien.HoTen,
ID = a.DoanVien.ID,
NgaySinh = a.DoanVien.NgaySinh.ToShortDateString(),
DiaChi = a.DoanVien.DiaChi,
NgayVaoDoan = a.DoanVien.NgayVaoDoan.ToShortDateString(),
Email = a.DoanVien.Email,
GioiTinh = a.DoanVien.GioiTinh ? "Nam" : "Nữ",
SoDienThoai = a.DoanVien.SoDienThoai
}).ToList();
if (lst.Count > 0)
{
return(Json(false, JsonRequestBehavior.AllowGet));
}
else
{
DangKy dk = new DangKy
{
IDDoanVien = ses.ID,
IDSuKien = IDSuKien,
NgayDangKy = DateTime.Now
};
db.DangKies.InsertOnSubmit(dk);
db.SubmitChanges();
return(Json(true, JsonRequestBehavior.AllowGet));
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (check_input())
{
linq.Tb_Vouchers.InsertOnSubmit(getvoucher());
linq.SubmitChanges();
MessageBox.Show("Voucher Saved Successfully");
Load_form();
}
}
private void btnXoa_Click(object sender, EventArgs e)
{
DialogResult tl = MessageBox.Show("Bạn Muốn Xóa ?", "Thông Báo", MessageBoxButtons.OKCancel);
if (tl == DialogResult.OK)
{
int n = dgvPhong.CurrentCell.RowIndex;
int iMaPH = Convert.ToInt32(dgvPhong.Rows[n].Cells[0].Value.ToString());
if (dbs.Liches.FirstOrDefault(p => p.Phong == iMaPH) != null)
{
MessageBox.Show("Phòng này Đang Được Phân Công, Không Thể Xóa", "Thông Báo");
}
else
{
PhongHoc ph = dbs.PhongHocs.First(p => p.MaPH == iMaPH);
dbs.PhongHocs.DeleteOnSubmit(ph);
dbs.SubmitChanges();
LoadData();
}
}
}
public JsonResult ChangePassWordUser(string PasswordOld, string PasswordNew)
{
ResponseBase res = new ResponseBase();
var ses = (UserSave)Session[Constant.USER_SESSION];
try
{
var dt = (from a in db.Users
where a.ID == ses.ID && a.Password == PasswordOld
select a).ToList();
if (dt.Count == 1)
{
dt.FirstOrDefault().Password = PasswordNew;
db.SubmitChanges();
res.Status = StatusID.Success;
res.Message = "Mật khẩu đã được thay đổi";
}
else
{
res.Status = StatusID.AccessDenied;
res.Message = "Mật khẩu cũ không đúng!";
}
}
catch (Exception ex)
{
res.Status = StatusID.AccessDenied;
res.Message = ex.Message;
}
return(Json(res, JsonRequestBehavior.AllowGet));
}
public static void FreeDate()
{
var bank = new LinqDataContext();
var query = from p in bank.sarbazs
// where p.Id_Sarbaz == Id_sarbaz
select p;
foreach (var items in query)
{
var x = items.مدت_كسر_خدمت_به_روز;
var y = items.خدمت_قبلی_روز;
var z = items.مدت_اضافه_خدمت_روز;
if (x == "" || x == null)
{
x = "0";
}
if (y == "" || y == null)
{
y = "0";
}
if (z == "" || z == null)
{
z = "0";
}
int Day_variable = -Convert.ToInt32(x)
- Convert.ToInt32(y)
+ Convert.ToInt32(z);
PersianCalendar pcalender = new PersianCalendar();
PersianDate pDateObj = new PersianDate();
int year = Convert.ToDateTime(items.تاریخ_اعزام).Year;
int month = Convert.ToDateTime(items.تاریخ_اعزام).Month;
int day = Convert.ToDateTime(items.تاریخ_اعزام).Day;
pDateObj.increasePersianMonth(ref year, ref month, 21);
DateTime date = pcalender.ToDateTime(year,
month,
day, 0, 0, 0, 0, 0
);
// DateTime date_FreeDate = date.AddMonths(21);
DateTime date_FreeDate1 = date.AddDays(Day_variable);
items.تاریخ_ترخیص = pcalender.GetYear(date_FreeDate1) + "/" +
pcalender.GetMonth(date_FreeDate1) + "/" +
pcalender.GetDayOfMonth(date_FreeDate1);
}
//return date_FreeDate;
bank.SubmitChanges();
}
private void btnLuu_Click(object sender, EventArgs e)
{
DialogResult tl = MessageBox.Show("Bạn Muốn Lưu ?", "Thông Báo", MessageBoxButtons.OKCancel);
if (tl == DialogResult.OK)
{
Nhom nh;
if (flag)
{
nh = new Nhom();
if (dbs.Nhoms.Count() == 0)
{
nh.myIndex = 1;
}
else
{
nh.myIndex = Convert.ToInt32(dbs.Nhoms.Max(p => p.myIndex)) + 1;
}
nh.MaNhom = Convert.ToInt32(nh.myIndex) + 1;
}
else
{
int n = dgvNhom.CurrentCell.RowIndex;
int iMaNhom = Convert.ToInt32(dgvNhom.Rows[n].Cells[0].Value.ToString());
nh = dbs.Nhoms.FirstOrDefault(p => p.MaNhom == iMaNhom);
}
nh.SV1 = txtSV1.Text;
nh.SV2 = txtSV2.Text;
if (flag)
{
dbs.Nhoms.InsertOnSubmit(nh);
}
dbs.SubmitChanges();
}
LoadData();
}
private void btn_Save_Click(object sender, EventArgs e)
{
if (check_input())
{
Tb_HrEmp emp = (Tb_HrEmp)(from x in linq.Tb_HrEmps
where x.EmpNo == Emp_No.Text
select x).SingleOrDefault();
emp.FullNameArab = FullNameArabTextEdit.Text;
emp.FullNameEng = FullNameEngTextEdit.Text;
emp.IqamaNo = IqamaNoTextEdit.Text;
linq.SubmitChanges();
MessageBox.Show(" Employee Updated Successfully");
Loadagain();
}
}
private void Bbtn_Save_ItemClick(object sender, ItemClickEventArgs e)
{
gridView1.PostEditor();
gridView1.RefreshData();
for (int i = 0; i < gridView1.RowCount; i++)
{
var x = (from t in linq.Vouchers_Types
where t.id == types[i].id
select t).SingleOrDefault();
if (x != null)
{
x.deducted_from_salary = Convert.ToBoolean(gridView1.GetRowCellValue(i, "deducted_from_salary"));
x.id = Convert.ToInt32(gridView1.GetRowCellDisplayText(i, "id"));
x.Type = Convert.ToString(gridView1.GetRowCellDisplayText(i, "Type"));
linq.SubmitChanges();
}
else
{
linq.Vouchers_Types.InsertOnSubmit(types[i]);
linq.SubmitChanges();
}
}
MessageBox.Show("Saved Successfully");
}
private void btn_Save_Click(object sender, EventArgs e)
{
LinqDataContext linq = new LinqDataContext(Properties.Settings.Default.ConnectionString);
Voucher.Tb_HrEmp emp = new Voucher.Tb_HrEmp();
emp.EmpNo = EmpNoTextEdit.Text;
emp.FullNameArab = FullNameArabTextEdit.Text;
emp.FullNameEng = FullNameArabTextEdit.Text;
emp.IqamaNo = FullNameArabTextEdit.Text;
emp.Is_deleted = false;
linq.Tb_HrEmps.InsertOnSubmit(emp);
linq.SubmitChanges();
MessageBox.Show("New Employee Added Successfully");
Loadagain();
}
public static void Estehghaghi()
{
var bank = new LinqDataContext();
var query = from p in bank.sarbazs
// where p.Id_Sarbaz==Id_sarbaz
select p;
foreach (var items in query)
{
var x = items.مدت_كسر_خدمت_به_روز;
var y = items.خدمت_قبلی_روز;
var z = items.مدت_اضافه_خدمت_روز;
if (x == "" || x == null)
{
x = "0";
}
if (y == "" || y == null)
{
y = "0";
}
if (z == "" || z == null)
{
z = "0";
}
int Day_variable = -Convert.ToInt32(x)
- Convert.ToInt32(y)
+ Convert.ToInt32(z);
double Mounth_Variable = Convert.ToInt32(Day_variable / 30);
var Khedmat_Mounth = 21 + Mounth_Variable;
int E;
if (items.تاهل == true)
{
E = Convert.ToInt32(Khedmat_Mounth * 2.5);
}
else
{
E = Convert.ToInt32(Khedmat_Mounth * 1);
}
items.استحقاقی = Convert.ToString(E);
}
bank.SubmitChanges();
// return E;
}
private void btnDelete_ItemClick(object sender, ItemClickEventArgs e)
{
var gv = gridControl.MainView as GridView;
var index = gv.FocusedRowHandle;
string emp_no = gv.GetRowCellValue(index, "EmpNo").ToString();
string emp_Name = gv.GetRowCellValue(index, "FullNameEng").ToString();
DialogResult Dr = MessageBox.Show("Do you Want to delete this employee (" + emp_Name + ")", "Warning", MessageBoxButtons.YesNo, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button2);
if (Dr == DialogResult.Yes)
{
Tb_HrEmp Tb_HrEmps = (from emp in linq.Tb_HrEmps
where emp.EmpNo == emp_no
select emp).SingleOrDefault();
Tb_HrEmps.Is_deleted = true;
linq.SubmitChanges();
MessageBox.Show(emp_Name + " deleted Successfly");
load_data();
}
}
private void btnApply_Click(object sender, EventArgs e)
{
var LinqObj = new LinqDataContext();
var query = (from tempTbl in LinqObj.Mashmoolins
where tempTbl.Id_Mashmoolin == int.Parse(txtID_M.Text)
select tempTbl).Single();
query.شماره_ملی = this.txtID.Text;
query.نام = this.txtName.Text;
query.نام_خانوادگی = this.txtLastName.Text;
query.نام_پدر = this.txtFatherName.Text;
query.تاریخ_تولد = txt_BirthYear.Text;
query.آدرس = txt_Address.Text;
query.تلفن = txt_mobile.Text;
query.تحصیلات = comboBox_Grade.Text.ToString();
query.کد_تحصیلات = Convert.ToInt32(comboBox_Grade.SelectedValue);
query.رشته = txt_Reshteh.Text;
query.معرف = txt_Moaref.Text;
query.سابقه_بسیج_فعال = txt_Basij.Text;
query.حوزه_جذب = txt_HozehJazb.Text;
query.اضاف = txt_Ezaf.Text;
query.تکمیلی = chBox_Takmili.Checked;
query.سی_روزه = chBox_ThirthDay.Checked;
query.معاف_از_رزم = chBox_Moaf.Checked;
query.کمیته_امداد = chBox_Komiteh.Checked;
query.سازمان_بهزیستی = chBox_Behzisti.Checked;
query.تاهل = chBox_Taahol.Checked;
query.توضیحات = txt_Explain.Text;
query.تاریخ_اعزام = txt_EzamDate.Text;
LinqObj.SubmitChanges();
this.Close();
}
private void btnApply_Click(object sender, EventArgs e)
{
try
{
var LinqObj = new LinqDataContext();
var GradeReshtehObj = new Grade_Reshteh();
var c = LinqObj.Grade_Reshtehs.Count();
if (GVFeildCapacity.RowCount >= 1)
{
for (int i = 1; i <= c; i++)
{
if (GVFeildCapacity.Rows[i].Cells[4].Value.ToString() == "")
{
GradeReshtehObj.Capacity = int.Parse(GVFeildCapacity.Rows[i].Cells[4].Value.ToString());
}
LinqObj.Grade_Reshtehs.InsertOnSubmit(GradeReshtehObj);
}
LinqObj.SubmitChanges();
///////////////// referesh GVtable /////////////
var bank = new LinqDataContext();
var query = from temp in bank.Grade_Reshtehs
join tempjoin in bank.Reshtehas on temp.Id_CodeReshteh equals tempjoin.Id
join tempjoin2 in bank.Gradetbls on temp.Id_Grade equals tempjoin2.Id_Grade
select new { temp.Id_Grade_Reshteh, tempjoin2.Grade, tempjoin.Reshteh, tempjoin.CodeReshteh, temp.Capacity };
GVFeildCapacity.DataSource = query;
//////////////////////////////////////////////////
}
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
btnThem.Enabled = true;
btnSua.Enabled = true;
btnXoa.Enabled = true;
DialogResult tl = MessageBox.Show("Bạn Muốn Lưu ?", "Thông Báo", MessageBoxButtons.OKCancel);
if (tl == DialogResult.OK)
{
if (checkAlreadyExist())
{
MessageBox.Show("Thông Tin Bị Trùng Xem Lại Thông Tin Vừa Nhập", "Thông Báo");
}
else
{
if (!String.IsNullOrEmpty(txtNamHoc.Text) && !String.IsNullOrEmpty(txtTenDT.Text) && !String.IsNullOrEmpty(cbbHocKy.Text))
{
DeTai detai = new DeTai();
detai.TenDT = txtTenDT.Text;
detai.NamHoc = Convert.ToInt32(txtNamHoc.Text);
detai.HocKy = Convert.ToInt32(cbbHocKy.Text);
if (flag)
{
dbs.DeTais.InsertOnSubmit(detai);
}
else
{
int n = dgvDeTai.CurrentCell.RowIndex;
string TenDeTai = dgvDeTai.Rows[n].Cells[0].Value.ToString();
int NamHoc = Convert.ToInt32(dgvDeTai.Rows[n].Cells[1].Value);
int HocKy = Convert.ToInt32(dgvDeTai.Rows[n].Cells[2].Value);
PhanCong pc = dbs.PhanCongs.FirstOrDefault(p => p.DeTai.TenDT == TenDeTai && p.DeTai.NamHoc == NamHoc && p.DeTai.HocKy == HocKy);
if (pc != null)
{
pc.DeTai = null;
dbs.SubmitChanges();
}
var dt = dbs.DeTais.FirstOrDefault(p => p.TenDT == TenDeTai && p.NamHoc == NamHoc && p.HocKy == HocKy);
dbs.DeTais.DeleteOnSubmit(dt);
if (pc != null)
{
dbs.DeTais.InsertOnSubmit(detai);
pc.DeTai.TenDT = txtTenDT.Text;
pc.DeTai.NamHoc = Convert.ToInt32(txtNamHoc.Text);
pc.DeTai.HocKy = Convert.ToInt32(cbbHocKy.Text);
}
else
{
dbs.DeTais.InsertOnSubmit(detai);
}
}
dbs.SubmitChanges();
LoadData();
}
else
{
MessageBox.Show("Nhập Thiếu", "Thông Báo");
}
}
}
}
private void btnApply_Click(object sender, EventArgs e)
{
try
{
//int counter=1;
if (this.txtID_M.Text == "" || this.txtName.Text == "" || this.txtLastName.Text == "" || this.txtFatherName.Text == "")
{
MessageBox.Show("لطفا موارد خواسته شده را پر نمایید");
}
else
{
var db = new LinqDataContext();
var query_Id = from p in db.Mashmoolins
select p.شماره_ملی;
var x = txtID.Text;
foreach (var items in query_Id)
{
if (x == items)
{
MessageBox.Show("شماره ملی موجود است!"); return;
}
}
var M = new Mashmoolin();
M.شماره_ملی = txtID.Text;
M.نام = txtName.Text;
M.نام_خانوادگی = txtLastName.Text;
M.نام_پدر = txtFatherName.Text;
M.تاریخ_تولد = txt_BirthYear.Text;
M.آدرس = txt_Address.Text;
M.تلفن = txt_mobile.Text;
M.تحصیلات = comboBox_Grade.Text.ToString();
M.کد_تحصیلات = Convert.ToInt32(comboBox_Grade.SelectedValue);
M.رشته = txt_Reshteh.Text;
M.معرف = txt_Moaref.Text;
M.سابقه_بسیج_فعال = txt_Basij.Text;
M.حوزه_جذب = txt_HozehJazb.Text;
M.اضاف = txt_Ezaf.Text;
M.تکمیلی = chBox_Takmili.Checked;
M.سی_روزه = chBox_ThirthDay.Checked;
M.معاف_از_رزم = chBox_Moaf.Checked;
M.کمیته_امداد = chBox_Komiteh.Checked;
M.سازمان_بهزیستی = chBox_Behzisti.Checked;
M.تاهل = chBox_Taahol.Checked;
M.توضیحات = txt_Explain.Text;
M.تاریخ_اعزام = txt_EzamDate.Text;
db.Mashmoolins.InsertOnSubmit(M);
db.SubmitChanges();
this.Close();
}
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
DialogResult tl = MessageBox.Show("Bạn Muốn Lưu ?", "Thông Báo", MessageBoxButtons.OKCancel);
if (tl == DialogResult.OK)
{
if (String.IsNullOrEmpty(txtChucVu.Text) || String.IsNullOrEmpty(txtDiaChi.Text) || String.IsNullOrEmpty(txtEmail.Text) || String.IsNullOrEmpty(txtSDT.Text) || String.IsNullOrEmpty(txtSLDeTai.Text) || String.IsNullOrEmpty(txtTenGV.Text))
{
MessageBox.Show("Nhập Thiếu Thông Tin", "Thông Báo");
}
else
{
GiangVien gv;
if (flag)
{
gv = new GiangVien();
if (dbs.GiangViens.Count() == 0)
{
gv.myIndex = 1;
}
else
{
gv.myIndex = Convert.ToInt32(dbs.GiangViens.Max(p => p.myIndex)) + 1;
}
gv.MaGV = Convert.ToInt32(gv.myIndex);
}
else
{
int n = dgvGiangVien.CurrentCell.RowIndex;
int sMaGV = Convert.ToInt32(dgvGiangVien.Rows[n].Cells[0].Value.ToString());
gv = dbs.GiangViens.First(p => p.MaGV == sMaGV);
}
gv.TenGV = txtTenGV.Text;
gv.SDT = txtSDT.Text;
if (txtSLDeTai.Text == null || string.IsNullOrEmpty(txtSLDeTai.Text))
{
gv.SLDeTaiToiDa = 0;
}
else
{
gv.SLDeTaiToiDa = Convert.ToInt32(txtSLDeTai.Text);
}
gv.ChucVu = txtChucVu.Text;
gv.DiaChi = txtDiaChi.Text;
gv.Email = txtEmail.Text;
if (ckbGioiTinh.Checked)
{
gv.GioiTinh = "Nam";
}
else
{
gv.GioiTinh = "Nữ";
}
if (flag)
{
dbs.GiangViens.InsertOnSubmit(gv);
}
dbs.SubmitChanges();
}
LoadData();
}
}
private void btnApply_Click(object sender, EventArgs e)
{
try
{
//int counter=1;
if (this.txtIDSarbaz.Text == "" || this.txtName.Text == "" || this.txtLastName.Text == "" || this.txtFatherName.Text == "")
{
MessageBox.Show("لطفا موارد خواسته شده را پر نمایید");
}
else
{
var db = new LinqDataContext();
var query_Id = from p in db.sarbazs
select p.شماره_ملی;
var x = txtID.Text;
foreach (var items in query_Id)
{
if (x == items)
{
MessageBox.Show("شماره ملی موجود است!"); return;
}
}
var S = new sarbaz();
S.شماره_ملی = txtID.Text;
S.نام = txtName.Text;
S.نام_خانوادگی = txtLastName.Text;
S.نام_پدر = txtFatherName.Text;
S.تاریخ_تولد = txt_BirthYear.Text;
S.آدرس = txt_Address.Text;
S.تلفن = txt_mobile.Text;
S.تحصیلات = comboBox_Grade.Text.ToString();
S.کد_تحصیلات = Convert.ToInt32(comboBox_Grade.SelectedValue);
S.رشته = txt_Reshteh.Text;
S.معرف = txt_Moaref.Text;
S.سابقه_بسیج_فعال = txt_Basij.Text;
S.حوزه_خدمت = txt_Hozeh.Text;
S.تاهل = chBox_Taahol.Checked;
S.تکمیلی = chBox_Takmili.Checked;
S.سی_روزه = chBox_ThirthDay.Checked;
S.معاف_از_رزم = chBox_Moaf.Checked;
S.کمیته_امداد = chBox_Komiteh.Checked;
S.سازمان_بهزیستی = chBox_Behzisti.Checked;
S.بومی = chBox_Boomi.Checked;
S.فرمانده_دسته = chBox_FarmandeD.Checked;
S.فراری = chBox_Farari.Checked;
S.کمیسیون = chBox_Komision.Checked;
S.توضیحات = txt_Explain.Text;
S.تاریخ_اعزام = txt_EzamDate.Text;
S.درجه = comboBox_Darajeh.Text;
S.کد_درجه = Convert.ToInt32(comboBox_Darajeh.SelectedValue);
S.تاریخ_معرفی = txt_JazbDate.Text;
S.مدت_اضافه_خدمت_روز = txt_Ezaf.Text;
S.خدمت_قبلی_روز = txt_LastKhedmat.Text;
S.مدت_كسر_خدمت_به_روز = txt_kasri_day.Text;
// S.استحقاقی =Convert.ToInt32( txt_Estehghaghi.Text);
// S.تاریخ_ترخیص = Convert.ToDateTime(txt_FreeDate.Text);
S.مامور = chBox_MissionFlag.Checked;
S.مدت_ماموریت_ماه_ = txt_MissionDate.Text;
S.محل_ماموریت = txt_MissionLocation.Text;
db.sarbazs.InsertOnSubmit(S);
db.SubmitChanges();
this.Close();
}
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
private void btnLuu_Click(object sender, EventArgs e)
{
DialogResult tl = MessageBox.Show("Bạn Muốn Lưu ?", "Thông Báo", MessageBoxButtons.OKCancel);
if (tl == DialogResult.OK)
{
if (String.IsNullOrEmpty(cbbGVHD.Text) || String.IsNullOrEmpty(cbbHocKy.Text) || String.IsNullOrEmpty(cbbNhomSV.Text) || String.IsNullOrEmpty(cbbTenDT.Text) || string.IsNullOrEmpty(cbbNamHoc.Text))
{
MessageBox.Show("Nhập Thiếu Thông Tin", "Thông Báo");
}
else
if (checkError())
{
MessageBox.Show("Thông Tin Nhập Vào Không Đúng,Xem Lại Thông Tin Vừa Nhập", "Thông Báo");
}
else
{
PhanCong pc;
if (flag)
{
pc = new PhanCong();
if (dbs.PhanCongs.Count() == 0)
{
pc.myIndex = 1;
}
else
{
pc.myIndex = Convert.ToInt32(dbs.PhanCongs.Max(p => p.myIndex)) + 1;
}
pc.MaPC = Convert.ToInt32(pc.myIndex) + 1;
pc.GVHuongDan = Convert.ToInt32(cbbGVHD.SelectedValue);
pc.TenDeTai = cbbTenDT.Text;
pc.MaNhom = Convert.ToInt32(cbbNhomSV.Text);
pc.HocKy = Convert.ToInt32(cbbHocKy.Text);
pc.NamHoc = Convert.ToInt32(cbbNamHoc.Text);
dbs.PhanCongs.InsertOnSubmit(pc);
}
else
{
int n = dgvPhanCong.CurrentCell.RowIndex;
int iMaPC = Convert.ToInt32(dgvPhanCong.Rows[n].Cells[0].Value.ToString());
// dbs.SubmitChanges();
pc = dbs.PhanCongs.First(p => p.MaPC == iMaPC);
pc.GiangVien = dbs.GiangViens.FirstOrDefault(p => p.MaGV == Convert.ToInt32(cbbGVHD.SelectedValue));
pc.DeTai = dbs.DeTais.FirstOrDefault(p => p.TenDT == cbbTenDT.Text && p.HocKy == Convert.ToInt32(cbbHocKy.Text) && p.NamHoc == Convert.ToInt32(cbbNamHoc.Text));
// pc.TenDeTai = cbbTenDT.Text;
pc.MaNhom = Convert.ToInt32(cbbNhomSV.Text);
pc.HocKy = Convert.ToInt32(cbbHocKy.Text);
if (String.IsNullOrEmpty(cbbNamHoc.Text))
{
pc.NamHoc = 0;
}
else
{
pc.NamHoc = Convert.ToInt32(cbbNamHoc.Text);
}
}
dbs.SubmitChanges();
LoadData();
}
}
}
private void btnApply_Click(object sender, EventArgs e)
{
try
{
var LinqObj = new LinqDataContext();
var query = (from tempTbl in LinqObj.sarbazs
where tempTbl.Id_Sarbaz == int.Parse(txtIDSarbaz.Text)
select tempTbl).Single();
query.شماره_ملی = this.txtID.Text;
query.نام = this.txtName.Text;
query.نام_خانوادگی = this.txtLastName.Text;
query.نام_پدر = this.txtFatherName.Text;
query.آدرس = txt_Address.Text;
query.تلفن = txt_mobile.Text;
query.تحصیلات = comboBox_Grade.Text;
query.کد_تحصیلات = Convert.ToInt32(comboBox_Grade.SelectedValue);
query.رشته = txt_Reshteh.Text;
query.تلفن = txt_mobile.Text;
query.تاریخ_تولد = txt_BirthYear.Text;
query.حوزه_خدمت = txt_Hozeh.Text;
query.معرف = txt_Moaref.Text;
query.سابقه_بسیج_فعال = txt_Basij.Text;
query.تاهل = chBox_Taahol.Checked;
query.تکمیلی = chBox_Takmili.Checked;
query.سی_روزه = chBox_ThirthDay.Checked;
query.معاف_از_رزم = chBox_Moaf.Checked;
query.کمیته_امداد = chBox_Komiteh.Checked;
query.سازمان_بهزیستی = chBox_Behzisti.Checked;
query.بومی = chBox_Boomi.Checked;
query.فرمانده_دسته = chBox_FarmandeD.Checked;
query.فراری = chBox_Farari.Checked;
query.کمیسیون = chBox_Komision.Checked;
query.توضیحات = txt_Explain.Text;
query.تاریخ_اعزام = txt_EzamDate.Text;
query.تاریخ_معرفی = txt_JazbDate.Text;
query.درجه = comboBox_Darajeh.Text;
query.کد_درجه = Convert.ToInt32(comboBox_Darajeh.SelectedValue);
query.مدت_اضافه_خدمت_روز = txt_Ezaf.Text;
query.خدمت_قبلی_روز = txt_LastKhedmat.Text;
query.مدت_كسر_خدمت_به_روز = txt_kasri_day.Text;
// query.استحقاقی =Convert.ToInt32( txt_Estehghaghi.Text);
// query.تاریخ_ترخیص =Convert.ToDateTime( txt_FreeDate.Text);
query.مامور = chBox_MissionFlag.Checked;
query.مدت_ماموریت_ماه_ = txt_MissionDate.Text;
query.محل_ماموریت = txt_MissionLocation.Text;
LinqObj.SubmitChanges();
this.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void TaoLich()
{
DialogResult tl = MessageBox.Show("Bạn Muốn Tạo Lịch Mới (Lịch Cũ Sẽ Bị Xóa) Theo chi tiết bên dưới", "Thông Báo", MessageBoxButtons.OKCancel);
if (tl == DialogResult.OK)
{
//000
if (cbbTenGV.Text.Equals("Tất Cả"))
{
if (cbbTenGV.Text.Equals("Tất Cả") && cbbNamHoc.Text.Equals("Tất Cả") && cbbHocKy.Text.Equals("Tất Cả"))
{
var PhanCong = from x in dbs.PhanCongs select x;
foreach (PhanCong pc in PhanCong)
{
phanCongRanDomGV(pc);
}
var lich = from x in dbs.Liches select x;
dbs.Liches.DeleteAllOnSubmit(lich);
TaoLichRanDom(true, true, true);
}
//010
if (cbbTenGV.Text.Equals("Tất Cả") && !cbbNamHoc.Text.Equals("Tất Cả") && cbbHocKy.Text.Equals("Tất Cả"))
{
var lich = from li in dbs.Liches
from pc in dbs.PhanCongs
where li.MaPC == pc.MaPC && pc.NamHoc == Convert.ToInt32(cbbNamHoc.Text)
select li;
dbs.Liches.DeleteAllOnSubmit(lich);
TaoLichRanDom(true, false, true);
}
//001
if (cbbTenGV.Text.Equals("Tất Cả") && cbbNamHoc.Text.Equals("Tất Cả") && !cbbHocKy.Text.Equals("Tất Cả"))
{
var lich = from li in dbs.Liches
from pc in dbs.PhanCongs
where li.MaPC == pc.MaPC && pc.HocKy == Convert.ToInt32(cbbHocKy.Text)
select li;
dbs.Liches.DeleteAllOnSubmit(lich);
TaoLichRanDom(true, true, false);
}
//011
if (cbbTenGV.Text.Equals("Tất Cả") && !cbbNamHoc.Text.Equals("Tất Cả") && !cbbHocKy.Text.Equals("Tất Cả"))
{
var lich = from li in dbs.Liches
from pc in dbs.PhanCongs
where li.MaPC == pc.MaPC && pc.HocKy == Convert.ToInt32(cbbHocKy.Text) && pc.NamHoc == Convert.ToInt32(cbbNamHoc.Text)
select li;
dbs.Liches.DeleteAllOnSubmit(lich);
TaoLichRanDom(true, false, false);
}
dbs.SubmitChanges();
LoadData();
}
else
{
MessageBox.Show("Mục Giảng Viên Phải Chọn Tất Cả", "Error");
}
}
}