private void guna2Button2_Click(object sender, EventArgs e)
{
using (var context = new YTeDbContext())
{
var phongKham = context.PhongKhams.Where(s => s.TenPhongKham == phongkham).FirstOrDefault();
var People = context.DatLichKhams.Where(s => s.ID_PhongKham == phongKham.ID_PhongKham).FirstOrDefault();
var people = new ConNguoi();
{
people.HoTen = txtHoTen.Text;
people.SoCMND = txtCMND.Text;
people.SoDienThoai = txtSDT.Text;
people.Email = txtEmail.Text;
people.DiaChi = txtDiaChi.Text;
// people.GioiTinh = cbGioiTinh.Text;
}
context.ConNguois.Add(people);
context.SaveChanges();
var connguoi = new DatLichKham();
{
connguoi.GhiChu = txtGhiChu.Text;
connguoi.LyDoKham = txtLyDoKham.Text;
connguoi.ID_PhongKham = People.ID_PhongKham;
}
context.DatLichKhams.Add(connguoi);
context.SaveChanges();
}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["HoTen"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string DatLichKhamID, Priority, IsAvailable;
var oDatLichKham = new DatLichKham();
foreach (GridDataItem item in RadGrid1.Items)
{
DatLichKhamID = item.GetDataKeyValue("DatLichKhamID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oDatLichKham.DatLichKhamQuickUpdate(
DatLichKhamID,
IsAvailable,
Priority
);
}
}
//else if (e.CommandName == "DeleteSelected")
//{
// var oDatLichKham = new DatLichKham();
// foreach (GridDataItem item in RadGrid1.SelectedItems)
// {
// string strDatLichKhamImage = ((HiddenField)item.FindControl("hdnDatLichKhamImage")).Value;
// if (!string.IsNullOrEmpty(strDatLichKhamImage))
// {
// string strSavePath = Server.MapPath("~/res/DatLichKham/" + strDatLichKhamImage);
// if (File.Exists(strSavePath))
// File.Delete(strSavePath);
// }
// }
//}
else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
{
var command = e.CommandName;
var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
string strDatLich = ((RadioButtonList)row.FindControl("radioDatLich")).SelectedValue;
string strHoTen = ((TextBox)row.FindControl("txtHoTen")).Text.Trim();
var dpNgaySinh = (RadDatePicker)row.FindControl("dpNgaySinh");
string strNgaySinh = dpNgaySinh.SelectedDate.HasValue ? dpNgaySinh.SelectedDate.Value.ToShortDateString() : "";
string strGioiTinh = ((RadioButtonList)row.FindControl("radioGioiTinh")).SelectedValue;
string strDienThoai = ((TextBox)row.FindControl("txtDienThoai")).Text.Trim();
string strEmail = ((TextBox)row.FindControl("txtEmail")).Text.Trim();
string strChuyenKhoa = ((DropDownList)row.FindControl("dropChuyenKhoa")).SelectedValue;
string strBacSi = ((DropDownList)row.FindControl("dropBacSi")).SelectedValue;
string strMoTa = ((TextBox)row.FindControl("txtMoTa")).Text.Trim();
var dpNgayKham = (RadDatePicker)row.FindControl("dpNgayKham");
var dpGioKham = (RadTimePicker)row.FindControl("dpGioKham");
var strNgayKham = dpNgayKham.SelectedDate.HasValue ? dpNgayKham.SelectedDate.Value.ToShortDateString() : "";
var strGioKham = dpGioKham.SelectedDate.HasValue ? dpGioKham.SelectedDate.Value.ToShortTimeString() : "";
strNgayKham = string.IsNullOrEmpty(strNgayKham) ? "" : strNgayKham + " " + strGioKham;
string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
string strPriority = ((RadNumericTextBox)row.FindControl("txtPriority")).Text.Trim();
var oDatLichKham = new DatLichKham();
if (e.CommandName == "PerformInsert")
{
oDatLichKham.DatLichKhamInsert(
strDatLich,
strHoTen,
strNgaySinh,
strGioiTinh,
strDienThoai,
strEmail,
strChuyenKhoa,
strBacSi,
strMoTa,
strNgayKham,
"",
strIsAvailable,
strPriority
);
RadGrid1.Rebind();
//var dsInsertParam = ObjectDataSource1.InsertParameters;
//dsInsertParam["DatLichCho"].DefaultValue = strDatLich;
//dsInsertParam["HoTen"].DefaultValue = strHoTen;
//dsInsertParam["NgaySinh"].DefaultValue = strNgaySinh;
//dsInsertParam["GioiTinh"].DefaultValue = strGioiTinh;
//dsInsertParam["DienThoai"].DefaultValue = strDienThoai;
//dsInsertParam["Email"].DefaultValue = strEmail;
//dsInsertParam["ProjectCategoryID"].DefaultValue = strChuyenKhoa;
//dsInsertParam["ProjectID"].DefaultValue = strBacSi;
//dsInsertParam["MoTa"].DefaultValue = strMoTa;
//dsInsertParam["NgayKham"].DefaultValue = strNgayKham;
//dsInsertParam["IsAvailable"].DefaultValue = strIsAvailable;
//dsInsertParam["Priority"].DefaultValue = strPriority;
}
else
{
var dsUpdateParam = ObjectDataSource1.UpdateParameters;
var strDatLichKhamID = row.GetDataKeyValue("DatLichKhamID").ToString();
//var strOldDatLichKhamImage = ((HiddenField)row.FindControl("hdnDatLichKhamImage")).Value;
//var strOldImagePath = Server.MapPath("~/res/DatLichKham/" + strOldDatLichKhamImage);
dsUpdateParam["DatLichCho"].DefaultValue = strDatLich;
dsUpdateParam["HoTen"].DefaultValue = strHoTen;
dsUpdateParam["NgaySinh"].DefaultValue = strNgaySinh;
dsUpdateParam["GioiTinh"].DefaultValue = strGioiTinh;
dsUpdateParam["DienThoai"].DefaultValue = strDienThoai;
dsUpdateParam["Email"].DefaultValue = strEmail;
dsUpdateParam["ProjectCategoryID"].DefaultValue = strChuyenKhoa;
dsUpdateParam["ProjectID"].DefaultValue = strBacSi;
dsUpdateParam["MoTa"].DefaultValue = strMoTa;
dsUpdateParam["NgayKham"].DefaultValue = strNgayKham;
dsUpdateParam["IsAvailable"].DefaultValue = strIsAvailable;
dsUpdateParam["Priority"].DefaultValue = strPriority;
}
}
//if (e.CommandName == "DeleteImage")
//{
// var oDatLichKham = new DatLichKham();
// var lnkDeleteImage = (LinkButton)e.CommandSource;
// var s = lnkDeleteImage.Attributes["rel"].ToString().Split('#');
// var strDatLichKhamID = s[0];
// var strDatLichKhamImage = s[1];
// oDatLichKham.DatLichKhamImageDelete(strDatLichKhamID);
// DeleteImage(strDatLichKhamImage);
// RadGrid1.Rebind();
//}
}
protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e)
{
if (e.CommandName == "alpha" || e.CommandName == "NoFilter")
{
String value = null;
switch (e.CommandName)
{
case ("alpha"):
{
value = string.Format("{0}%", e.CommandArgument);
break;
}
case ("NoFilter"):
{
value = "%";
break;
}
}
ObjectDataSource1.SelectParameters["HoTen"].DefaultValue = value;
ObjectDataSource1.DataBind();
RadGrid1.Rebind();
}
else if (e.CommandName == "QuickUpdate")
{
string DatLichKhamID, Priority, IsAvailable;
var oDatLichKham = new DatLichKham();
foreach (GridDataItem item in RadGrid1.Items)
{
DatLichKhamID = item.GetDataKeyValue("DatLichKhamID").ToString();
Priority = ((RadNumericTextBox)item.FindControl("txtPriority")).Text.Trim();
IsAvailable = ((CheckBox)item.FindControl("chkIsAvailable")).Checked.ToString();
oDatLichKham.DatLichKhamQuickUpdate(
DatLichKhamID,
IsAvailable,
Priority
);
}
}
//else if (e.CommandName == "PerformInsert" || e.CommandName == "Update")
//{
// var command = e.CommandName;
// var row = command == "PerformInsert" ? (GridEditFormInsertItem)e.Item : (GridEditFormItem)e.Item;
// string strIsAvailable = ((CheckBox)row.FindControl("chkIsAvailable")).Checked.ToString();
// string OriginNameEn = "";
// if (e.CommandName == "PerformInsert")
// {
// ObjectDataSource1.InsertParameters["IsAvailable"].DefaultValue = strIsAvailable;
// ObjectDataSource1.InsertParameters["OriginNameEn"].DefaultValue = OriginNameEn;
// }
// else
// {
// ObjectDataSource1.UpdateParameters["IsAvailable"].DefaultValue = strIsAvailable;
// ObjectDataSource1.UpdateParameters["OriginNameEn"].DefaultValue = OriginNameEn;
// }
//}
//else if (e.CommandName == "DeleteSelected")
//{
// var oOrigin = new Origin();
// string errorList = "", OriginName = "";
// foreach (GridDataItem item in RadGrid1.SelectedItems)
// {
// try
// {
// var OriginID = item.GetDataKeyValue("OriginID").ToString();
// OriginName = item["OriginName"].Text;
// oOrigin.OriginDelete(OriginID);
// }
// catch (Exception ex)
// {
// lblError.Text = ex.Message;
// if (ex.Message == ((int)ErrorNumber.ConstraintConflicted).ToString())
// errorList += ", " + OriginName;
// }
// }
// if (!string.IsNullOrEmpty(errorList))
// {
// e.Canceled = true;
// string strAlertMessage = "Xuất Xứ <b>\"" + errorList.Remove(0, 1).Trim() + " \"</b> đang chứa Sản Phẩm.<br /> Xin xóa Sản phẩm trong Xuất Xứ này hoặc thiết lập hiển thị = \"không\".";
// lblError.Text = strAlertMessage;
// }
//}
}
