private CenterModel BuildModel(center centerModule)
{
if (centerModule == null)
{
return(null);
}
else
{
CenterModel centermodel = new CenterModel();
centermodel.Id = centerModule.center_id;
centermodel.Name = centerModule.name;
centermodel.Phone = centerModule.phone;
centermodel.Address = centerModule.address;
if (centerModule.consultant_id.HasValue)
{
centermodel.ConsultantId = centerModule.consultant_id.Value;
centermodel.ConsultantName = centerModule.consultants.name;
}
else
{
centermodel.ConsultantId = 0;
centermodel.ConsultantName = "";
}
return(centermodel);
}
}
private void centerInfoDataGrid_SelectionChanged(object sender, System.Windows.Controls.SelectionChangedEventArgs e)
{
CenterModel p = (CenterModel)e.AddedItems[0];
SearchCenterId = p.CenterId;
SearchCenterName = p.CenterName;
}
public void SaveCenter(string CenterName, string CenterCode, string Email, string Landline1, string Landline2, string Mobile, string Address, string PinCode)
{
CenterModel CentObj1 = new CenterModel();
SqlParameter[] SParam = new SqlParameter[9];
SParam[0] = new SqlParameter("@CenterName", SqlDbType.VarChar);
SParam[0].Value = CenterName;
SParam[1] = new SqlParameter("@CenterCode", SqlDbType.VarChar);
SParam[1].Value = CenterCode;
SParam[2] = new SqlParameter("@Email", SqlDbType.VarChar);
SParam[2].Value = Email;
SParam[3] = new SqlParameter("@Landline1", SqlDbType.VarChar);
SParam[3].Value = Landline1;
SParam[4] = new SqlParameter("@Landline2", SqlDbType.VarChar);
SParam[4].Value = Landline2;
SParam[5] = new SqlParameter("@Mobile", SqlDbType.VarChar);
SParam[5].Value = Mobile;
SParam[6] = new SqlParameter("@Address", SqlDbType.VarChar);
SParam[6].Value = Address;
SParam[7] = new SqlParameter("@PinCode", SqlDbType.VarChar);
SParam[7].Value = PinCode;
SParam[8] = new SqlParameter("@UserID", SqlDbType.Int);
SParam[8].Value = Convert.ToInt32(Session["USER_ID"]);
try
{
CentObj1.SaveCenter(SParam);
}
catch (Exception ex)
{
}
}
public CenterModel Add(CenterModel newCenterModel)
{
try
{
center cen = new center();
cen.address = newCenterModel.Address;
cen.name = newCenterModel.Name;
cen.phone = newCenterModel.Phone;
if (newCenterModel.ConsultantId != 0)
{
cen.consultant_id = newCenterModel.ConsultantId;
}
_unitOfWork.AddAction(cen, DataActions.Add);
_unitOfWork.Save();
newCenterModel.Id = cen.center_id;
return(newCenterModel);
}
catch (RepositoryException rex)
{
string msg = rex.Message;
string reason = rex.StackTrace;
throw new FaultException <LCFault>
(new LCFault(msg), reason);
}
catch (Exception ex)
{
string msg = ex.Message;
string reason = ex.StackTrace;
throw new FaultException <LCFault>
(new LCFault(msg), reason);
}
}
/// <summary>
/// Service Method To Get Centers
/// </summary>
/// <param name="center"></param>
/// <returns></returns>
public static async Task <List <CenterModel> > GetCenter(CenterModel center)
{
List <CenterModel> centers = new List <CenterModel>();
using (SqlConnection dbConn = new SqlConnection(selectConnection(center.Location)))
{
var isExistingCenter = "SELECT * from Center";
SqlDataReader reader;
try
{
dbConn.Open();
SqlCommand cmd = new SqlCommand(isExistingCenter, dbConn);
reader = await cmd.ExecuteReaderAsync();
if (reader.HasRows)
{
while (reader.Read())
{
CenterModel centerItem = new CenterModel();
centerItem.ID = reader.GetInt32(0);
centerItem.Name = reader.GetString(1);
centerItem.CityID = reader.GetInt32(2);
centerItem.NoOfVoters = reader.GetInt32(3);
centers.Add(centerItem);
}
}
}
catch (Exception ex)
{
reader = null;
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Center Exists Error : " + ex.Message,
MethodName = "CenterExists",
IsError = true
},
center.Location);
}
finally
{
dbConn.Close();
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Check If Center Exists ",
MethodName = "CenterExists",
IsError = false
},
center.Location);
}
return(centers);
}
}
private void centerDataGrid_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (e.AddedItems.Count > 0)
{
CenterModel p = (CenterModel)e.AddedItems[0];
CenterIdTextBox.Text = p.CenterId;
CenterNameTextBox.Text = p.CenterName;
CenterCapacityTextBox.Text = p.CenterCapacity;
CenterCostTextBox.Text = p.CenterCost;
CenterFoodTextBox.Text = p.FoodCatering;
CenterLocationTextBox.Text = p.CenterLocation;
}
}
private async void DeleModule_Click(object sender, RoutedEventArgs e)
{
string strErrorMsg = string.Empty;
try
{
if (this._selectedCenter == null || this.centerList.SelectedItems.Count == 0)
{
await DialogManager.ShowMessageAsync(this.GetMainWindow(), UIResources.MsgInfo, "没有选择中心请选择！", MessageDialogStyle.Affirmative, null);
return;
}
MessageDialogResult result = await DialogManager.ShowMessageAsync(this.GetMainWindow(), UIResources.MsgInfo, "确认删除所选的中心吗！", MessageDialogStyle.AffirmativeAndNegative, null);
if (result == MessageDialogResult.Affirmative)
{
IAsyncProxy <ICenterService> _centerAyncProxy = await Task.Run(() => ServiceHelper.GetCenterService());
foreach (CenterModel item in this.centerList.SelectedItems)
{
await _centerAyncProxy.CallAsync(c => c.DeleteById(item.Id));
}
this._selectedCenter = null;
this.bindCenterList();
}
}
catch (TimeoutException timeProblem)
{
strErrorMsg = timeProblem.Message + UIResources.TimeOut + timeProblem.Message;
}
catch (FaultException <LCFault> af)
{
strErrorMsg = af.Detail.Message;
}
catch (FaultException unknownFault)
{
strErrorMsg = UIResources.UnKnowFault + unknownFault.Message;
}
catch (CommunicationException commProblem)
{
strErrorMsg = UIResources.ConProblem + commProblem.Message + commProblem.StackTrace;
}
catch (Exception ex)
{
strErrorMsg = ex.Message;
}
if (strErrorMsg != string.Empty)
{
await DialogManager.ShowMessageAsync(this.GetMainWindow(), UIResources.MsgError, "删除中心失败！原因：" + strErrorMsg, MessageDialogStyle.Affirmative, null);
}
}
/// <summary>
/// Service Method To Check If A Center Exists
/// </summary>
/// <param name="center"></param>
/// <returns></returns>
public static async Task <bool> CenterExists(CenterModel center)
{
using (SqlConnection dbConn = new SqlConnection(selectConnection(center.Location)))
{
var query = "SELECT * from Center WHERE Name ='" + center.Name + "' OR ID ='" + center.ID + "'";
SqlDataReader reader;
try
{
dbConn.Open();
SqlCommand cmd = new SqlCommand(query, dbConn);
reader = await cmd.ExecuteReaderAsync();
if (reader.HasRows)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
reader = null;
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Center Exists Error : " + ex.Message,
MethodName = "CenterExists",
IsError = true
},
center.Location);
return(false);
}
finally
{
dbConn.Close();
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Check If Center Exists ",
MethodName = "CenterExists",
IsError = false
},
center.Location);
}
}
}
public void DeleteCenter(int CenterID)
{
CenterModel CentObj1 = new CenterModel();
SqlParameter[] SParam = new SqlParameter[2];
SParam[0] = new SqlParameter("@UserID", SqlDbType.Int);
SParam[0].Value = Convert.ToInt32(Session["USER_ID"]);
SParam[1] = new SqlParameter("@CenterID", SqlDbType.Int);
SParam[1].Value = CenterID;
try
{
CentObj1.DeleteCenter(SParam);
}
catch { }
}
/// <summary>
/// Service Method To Add A New Center
/// </summary>
/// <param name="center"></param>
/// <returns></returns>
public static async Task <bool> AddNewCenter(CenterModel center)
{
String SQL = "INSERT INTO Center(Name,CityID,Voters)" +
"VALUES('" + center.Name + "','" + center.CityID + "','" + center.NoOfVoters + "')";
using (SqlConnection dbConn = new SqlConnection(selectConnection(center.Location)))
{
try
{
dbConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = SQL;
cmd.Connection = dbConn;
await cmd.ExecuteNonQueryAsync();
dbConn.Close();
return(true);
}
catch (Exception ex)
{
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Center Add Error : " + ex.Message,
MethodName = "AddNewCenter",
IsError = true
},
center.Location);
return(false);
}
finally
{
dbConn.Close();
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Center Added",
MethodName = "AddNewCenter",
IsError = false
},
center.Location);
}
}
}
/// <summary>
/// Service Method To Delete A Center
/// </summary>
/// <param name="center"></param>
/// <returns></returns>
public static async Task <bool> DeleteCenter(CenterModel center)
{
String SQL = "DELETE FROM Center WHERE Name = '" + center.Name + "' OR ID = '" + center.ID + "'";
using (SqlConnection dbConn = new SqlConnection(selectConnection(center.Location)))
{
try
{
dbConn.Open();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.CommandText = SQL;
cmd.Connection = dbConn;
await cmd.ExecuteNonQueryAsync();
dbConn.Close();
return(true);
}
catch (Exception ex)
{
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Center Delete Error : " + ex.Message,
MethodName = "DeleteCenter",
IsError = true
},
center.Location);
return(false);
}
finally
{
dbConn.Close();
ActionLogService.LogAction(new ActionLogModel()
{
UserID = center.UserID,
ActionPerformed = "Center Deleted",
MethodName = "DeleteCenter",
IsError = false
},
center.Location);
}
}
}
public async Task <IHttpActionResult> UpdateCenter(CenterModel center)
{
if (center == null)
{
return(BadRequest("Please provide valid inputs!"));
}
if (center.ID == 0)
{
return(BadRequest("Please provide valid center ID!"));
}
if (center.CityID == 0)
{
return(BadRequest("Please provide valid city ID!"));
}
if (string.IsNullOrEmpty(center.Location))
{
return(BadRequest("Please provide valid location!"));
}
if (await AuthService.ValidateUserAndToken(center.Token, center.UserID, center.Email, center.Location))
{
if (await CenterService.CenterExists(center))
{
if (await CenterService.UpdateCenter(center))
{
return(Ok("Center Updated Successfully!"));
}
else
{
return(BadRequest("Failed To Update Center!"));
}
}
else
{
return(BadRequest("No Such Center Exists!"));
}
}
else
{
return(Unauthorized());
}
}
private async void BindCenterInfo(CenterModel selectCenter)
{
string strErrorMsg = string.Empty;
try
{
if (selectCenter != null)
{
txtName.Text = selectCenter.Name;
txtMobile.Text = selectCenter.Phone;
txtAddress.Text = selectCenter.Address;
if (selectCenter.ConsultantId != 0)
{
//绑定主要管理的会籍顾问
cmbConsultant.SelectedValue = selectCenter.Id;
}
}
}
catch (TimeoutException timeProblem)
{
strErrorMsg = timeProblem.Message + UIResources.TimeOut + timeProblem.Message;
}
catch (FaultException <LCFault> af)
{
strErrorMsg = af.Detail.Message;
}
catch (FaultException unknownFault)
{
strErrorMsg = UIResources.UnKnowFault + unknownFault.Message;
}
catch (CommunicationException commProblem)
{
strErrorMsg = UIResources.ConProblem + commProblem.Message + commProblem.StackTrace;
}
catch (Exception ex)
{
strErrorMsg = ex.Message;
}
if (strErrorMsg != string.Empty)
{
await DialogManager.ShowMessageAsync(this, UIResources.MsgError, "绑定用户信息失败！原因：" + strErrorMsg, MessageDialogStyle.Affirmative, null);
}
}
private void Add_Button_Click_1(object sender, RoutedEventArgs e)
{
string centerName = Convert.ToString(Center_Name_textBox.Text);
string centerCapacity = Convert.ToString(Center_Capacity_textBox.Text);
string centerLocation = Convert.ToString(Center_Location_textBox.Text);
string centerCost = Convert.ToString(Center_Cost_textBox.Text);
string centerCatering = Convert.ToString(Center_Catering_textBox.Text);
CenterJobs.CenterModel newCenter = new CenterJobs.CenterModel(CenterModel.id(), centerName, centerCapacity, centerLocation, centerCost, centerCatering);
CenterJobs.CenterService cs = new CenterJobs.CenterService();
int i = cs.AddNewCenter(newCenter);
MainWindow mw = new MainWindow();
mw.centerDataGrid.ItemsSource = cs.LoadData();
this.Close();
}
public void SaveCSVCenterAndClassroomAndCoordinator(string EntityName, string CenterName, string CenterCode, string Password, string Fullname, string Email, string Mobile, string Landline1, string Address, string PinCode, string[] Classrooms)
{
CenterModel CentObj1 = new CenterModel();
SqlParameter[] SParam = new SqlParameter[9];
SParam[0] = new SqlParameter("EntityName", SqlDbType.VarChar);
SParam[0].Value = EntityName;
SParam[1] = new SqlParameter("@CenterName", SqlDbType.VarChar);
SParam[1].Value = CenterName;
SParam[2] = new SqlParameter("@CenterCode", SqlDbType.VarChar);
SParam[2].Value = CenterCode;
SParam[3] = new SqlParameter("@Email", SqlDbType.VarChar);
SParam[3].Value = Email;
SParam[4] = new SqlParameter("@Landline1", SqlDbType.VarChar);
SParam[4].Value = Landline1;
SParam[5] = new SqlParameter("@Mobile", SqlDbType.VarChar);
SParam[5].Value = Mobile;
SParam[6] = new SqlParameter("@Address", SqlDbType.VarChar);
SParam[6].Value = Address;
SParam[7] = new SqlParameter("@PinCode", SqlDbType.VarChar);
SParam[7].Value = PinCode;
SParam[8] = new SqlParameter("@UserID", SqlDbType.Int);
SParam[8].Value = Convert.ToInt32(Session["USER_ID"]);
DataTable Center = DAL.GetDataTable("CreateCSVCenter", SParam);
int CenterID = Convert.ToInt32(Convert.IsDBNull(Center.Rows[0]["CenterID"]) ? "-1" : Center.Rows[0]["CenterID"]);
foreach (var ClassroomName in Classrooms)
{
SaveClassroom(ClassroomName, CenterID, 50);
}
var RoleTable = DAL.GetDataTable("GetCenterCoordinatorRole");
int RoleID = Convert.ToInt32(Convert.IsDBNull(RoleTable.Rows[0]["RoleID"]) ? "-1" : RoleTable.Rows[0]["RoleID"]);
var e = new EntityController {
ControllerContext = ControllerContext
};
e.AddCenterUser(CenterID, Email, Password, Fullname, Email, Mobile, RoleID);
}
public async Task <IHttpActionResult> GetCenters(CenterModel center)
{
if (await AuthService.ValidateUserAndToken(center.Token, center.UserID, center.Email, center.Location))
{
var centers = await CenterService.GetCenter(center);
if (centers.Count > 0)
{
return(Ok(centers));
}
else
{
return(BadRequest("No Such Center Exists!"));
}
}
else
{
return(Unauthorized());
}
}
public bool Delete(CenterModel deleteCenterModel)
{
try
{
return(DeleteById(deleteCenterModel.Id));
}
catch (RepositoryException rex)
{
string msg = rex.Message;
string reason = rex.StackTrace;
throw new FaultException <LCFault>
(new LCFault(msg), reason);
}
catch (Exception ex)
{
string msg = ex.Message;
string reason = ex.StackTrace;
throw new FaultException <LCFault>
(new LCFault(msg), reason);
}
}
private async void centerList_SelectionChanged(object sender, SelectionChangedEventArgs e)
{
string strErrorMsg = string.Empty;
try
{
if (this.centerList.SelectedItems.Count == 0)
{
return;
}
this._selectedCenter = (CenterModel)this.centerList.SelectedItem;
await bindClassroom();
}
catch (TimeoutException timeProblem)
{
strErrorMsg = timeProblem.Message + UIResources.TimeOut + timeProblem.Message;
}
catch (FaultException <LCFault> af)
{
strErrorMsg = af.Detail.Message;
}
catch (FaultException unknownFault)
{
strErrorMsg = UIResources.UnKnowFault + unknownFault.Message;
}
catch (CommunicationException commProblem)
{
strErrorMsg = UIResources.ConProblem + commProblem.Message + commProblem.StackTrace;
}
catch (Exception ex)
{
strErrorMsg = ex.Message;
}
if (strErrorMsg != string.Empty)
{
await DialogManager.ShowMessageAsync(this.GetMainWindow(), UIResources.MsgError, "选取数据失败！原因：" + strErrorMsg, MessageDialogStyle.Affirmative, null);
}
}
public CenterModel Update(CenterModel newCenterModel)
{
try
{
Repository <center> centerDal = _unitOfWork.GetRepository <center>();
center cen = centerDal.GetObjectByKey(newCenterModel.Id).Entity;
if (cen != null)
{
cen.address = newCenterModel.Address;
cen.name = newCenterModel.Name;
cen.phone = newCenterModel.Phone;
if (newCenterModel.ConsultantId != 0)
{
cen.consultant_id = newCenterModel.ConsultantId;
}
}
_unitOfWork.AddAction(cen, DataActions.Update);
_unitOfWork.Save();
return(newCenterModel);
}
catch (RepositoryException rex)
{
string msg = rex.Message;
string reason = rex.StackTrace;
throw new FaultException <LCFault>
(new LCFault(msg), reason);
}
catch (Exception ex)
{
string msg = ex.Message;
string reason = ex.StackTrace;
throw new FaultException <LCFault>
(new LCFault(msg), reason);
}
}
private async void btnOK_Click(object sender, RoutedEventArgs e)
{
#region 新增
if (Om == OperationMode.AddMode)
{
string strErrorMsg = string.Empty;
try
{
CenterModel newCenterModel = new CenterModel();
newCenterModel.Name = txtName.Text.Trim();
newCenterModel.Address = txtAddress.Text.Trim();
newCenterModel.Phone = txtMobile.Text.Trim();
if (cmbConsultant.SelectedItem != null)
{
newCenterModel.ConsultantId = ((ConsultantModel)this.cmbConsultant.SelectedItem).Id;
}
else
{
newCenterModel.ConsultantId = 0;
}
newCenterModel = await centerAsyncProxy.CallAsync(c => c.Add(newCenterModel));
this.ShowAutoCloseDialogOwter(UIResources.MsgInfo, "新增教学中心成功！");
this.DialogResult = true;
}
catch (TimeoutException timeProblem)
{
strErrorMsg = timeProblem.Message + UIResources.TimeOut + timeProblem.Message;
}
catch (FaultException <LCFault> af)
{
strErrorMsg = af.Detail.Message;
}
catch (FaultException unknownFault)
{
strErrorMsg = UIResources.UnKnowFault + unknownFault.Message;
}
catch (CommunicationException commProblem)
{
strErrorMsg = UIResources.ConProblem + commProblem.Message + commProblem.StackTrace;
}
if (strErrorMsg != string.Empty)
{
await DialogManager.ShowMessageAsync(this, UIResources.MsgError, "新增中心信息失败！原因：" + strErrorMsg, MessageDialogStyle.Affirmative, null);
}
}
#endregion
#region 修改
else
{
string strErrorMsg = string.Empty;
try
{
selectCenter.Name = txtName.Text;
selectCenter.Phone = txtMobile.Text;
selectCenter.Address = txtAddress.Text;
if (cmbConsultant.SelectedItem != null)
{
selectCenter.ConsultantId = ((ConsultantModel)this.cmbConsultant.SelectedItem).Id;
}
else
{
selectCenter.ConsultantId = 0;
}
selectCenter = await centerAsyncProxy.CallAsync(c => c.Update(selectCenter));
this.ShowAutoCloseDialogOwter(UIResources.MsgInfo, "修改教学中心成功！");
this.DialogResult = true;
}
catch (TimeoutException timeProblem)
{
strErrorMsg = timeProblem.Message + UIResources.TimeOut + timeProblem.Message;
}
catch (FaultException <LCFault> af)
{
strErrorMsg = af.Detail.Message;
}
catch (FaultException unknownFault)
{
strErrorMsg = UIResources.UnKnowFault + unknownFault.Message;
}
catch (CommunicationException commProblem)
{
strErrorMsg = UIResources.ConProblem + commProblem.Message + commProblem.StackTrace;
}
if (strErrorMsg != string.Empty)
{
await DialogManager.ShowMessageAsync(this, UIResources.MsgError, "修改中心信息失败！原因：" + strErrorMsg, MessageDialogStyle.Affirmative, null);
}
}
#endregion
}
public ActionResult Create(/*[Bind(Include = "Name,Place,Desc,State,HolesN,Cityid")]*/ CenterModel centerModel, IEnumerable <HttpPostedFileBase> file)
{
if (Session["ID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
if (centerModel.DependedOn == null && centerModel.Cityid == null)
{
ViewBag.error = "الرجاء التأكد من اتمام معلومات المركز ومدينته";
ViewBag.TitleSideBar = "Centers";
return(View(centerModel));
}
bool sendImageError = false;
bool proceed = true;
bool NumberValidation = false;
var typeName = (string)Session["Type"];
var type = db.EmployeeTypes.Where(x => x.Type == typeName).FirstOrDefault();
var empid = Convert.ToInt32(Session["ID"]);
var employee = db.Employees.Find(empid);
if (centerModel.firstMonth > 9)
{
if (centerModel.LastMonth > 9 && centerModel.LastMonth < centerModel.firstMonth)
{
NumberValidation = true;
}
}
else if (centerModel.firstMonth > centerModel.LastMonth)
{
NumberValidation = true;
}
if (NumberValidation)
{
ViewBag.Periodid = new SelectList(db.Periods, "id", "Name");
ViewBag.error = "يرجى التأكد من الأشهر";
ViewBag.Cityid = new SelectList(db.Cities, "id", "Name");
ViewBag.TitleSideBar = "Centers";
return(View(centerModel));
}
if (ModelState.IsValid)
{
try
{
centerModel.center.id = db.Centers.OrderByDescending(x => x.id).FirstOrDefault().id + 1;
}
catch (Exception)
{
centerModel.center.id = 1;
}
int prooveid;
try
{
prooveid = db.Prooves.OrderByDescending(x => x.id).FirstOrDefault().id + 1;
}
catch (Exception)
{
prooveid = 1;
}
try
{
if ((Directory.Exists(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id)))
{
try
{
Directory.Delete(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id, true);
}
catch (IOException)
{
Directory.Delete(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id, true);
}
catch (UnauthorizedAccessException)
{
Directory.Delete(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id, true);
}
}
foreach (var item in file)
{
if (item.ContentLength > 0)
{
var fileName = Path.GetFileName(item.FileName);
if (!Directory.Exists(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id))
{
Directory.CreateDirectory(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id);
}
var path = Path.Combine(Server.MapPath("~/App_Data/Centers/" + centerModel.center.id), fileName);
item.SaveAs(path);
Proove proove = new Proove();
proove.Path = path;
proove.id = prooveid;
proove.CenterID = centerModel.center.id;
db.Prooves.Add(proove);
prooveid++;
}
else
{
}
}
var startPath = Server.MapPath("~/App_Data/Centers" + "\\" + centerModel.center.id);
if (!Directory.Exists(Server.MapPath("~/App_Data/Centers" + "\\" + "ZipFolder")))
{
Directory.CreateDirectory(Server.MapPath("~/App_Data/Centers" + "\\" + "ZipFolder"));
}
var zipPath = Server.MapPath("~/App_Data/Centers" + "\\" + "ZipFolder") + "\\" + centerModel.center.id + ".zip";
if (System.IO.File.Exists(zipPath))
{
System.IO.File.Delete(zipPath);
}
try
{
ZipFile.CreateFromDirectory(startPath, zipPath);
}
catch { }
centerModel.center.Proof = zipPath;
}
catch
{
}
centerModel.center.ProjectID = 1;
if (centerModel.firstMonth > centerModel.LastMonth)
{
for (int i = centerModel.firstMonth; i <= 12; i++)
{
switch (i)
{
case 10:
centerModel.center.Month10 = true;
break;
case 11:
centerModel.center.Month11 = true;
break;
case 12:
centerModel.center.Month12 = true;
break;
}
}
centerModel.firstMonth = 1;
}
for (int i = centerModel.firstMonth; i <= centerModel.LastMonth; i++)
{
switch (i)
{
case 1:
centerModel.center.Month1 = true;
break;
case 2:
centerModel.center.Month2 = true;
break;
case 3:
centerModel.center.Month3 = true;
break;
case 4:
centerModel.center.Month4 = true;
break;
case 5:
centerModel.center.Month5 = true;
break;
case 6:
centerModel.center.Month6 = true;
break;
case 7:
centerModel.center.Month7 = true;
break;
case 8:
centerModel.center.Month8 = true;
break;
case 9:
centerModel.center.Month9 = true;
break;
case 10:
centerModel.center.Month10 = true;
break;
case 11:
centerModel.center.Month11 = true;
break;
case 12:
centerModel.center.Month12 = true;
break;
}
}
if (centerModel.Cityid == null)
{
centerModel.center.Cityid = db.Centers.Find(centerModel.DependedOn).Cityid;
}
else
{
centerModel.center.Cityid = centerModel.Cityid;
}
centerModel.center.AddedBy = employee.id;
centerModel.center.AddingDate = DateTime.Now.Date;
centerModel.center.AddingTime = DateTime.Now.TimeOfDay;
centerModel.center.DependedOn = centerModel.DependedOn;
if (type.SeeAccToCity == true)
{
var id = Convert.ToInt32(Session["ID"]);
var emp = db.Employees.FirstOrDefault(x => x.id == id);
centerModel.center.Cityid = emp.CityID;
}
if (proceed)
{
db.Centers.Add(centerModel.center);
db.SaveChanges();
TempData["Message"] = "تم الادخال بنجاح";
return(RedirectToAction("Index"));
}
}
if (sendImageError)
{
ViewBag.error = "يرجى ارفاق الاثبات كملف خارجي";
}
if (type.SeeAccToCity == true)
{
ViewBag.Periodid = new SelectList(db.Periods, "id", "Name");
ViewBag.Cityid = new SelectList(db.Cities.Where(x => x.id == employee.CityID), "id", "Name");
ViewBag.DependedOn = new SelectList(db.Centers.Where(x => x.Cityid == employee.CityID && x.CenterType == "رئيسي"), "id", "Name");
}
else
{
ViewBag.Periodid = new SelectList(db.Periods, "id", "Name");
ViewBag.Cityid = new SelectList(db.Cities, "id", "Name");
ViewBag.DependedOn = new SelectList(db.Centers.Where(x => x.CenterType == "رئيسي"), "id", "Name");
}
ViewBag.TitleSideBar = "Centers";
return(View(centerModel));
}
// GET: Centers/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(RedirectToAction("Default", "Home"));
}
if (Session["ID"] != null)
{
var typeName = (string)Session["Type"];
var type = db.EmployeeTypes.Where(x => x.Type == typeName).FirstOrDefault();
if (type.AddCitesAndCenters == true)
{
CenterModel centerModel = new CenterModel();
centerModel.center = db.Centers.Find(id);
if (centerModel.center.Month10 == true)
{
centerModel.firstMonth = 10;
}
else if (centerModel.center.Month11 == true)
{
centerModel.firstMonth = 11;
}
else if (centerModel.center.Month12 == true)
{
centerModel.firstMonth = 12;
}
else if (centerModel.center.Month1 == true)
{
centerModel.firstMonth = 1;
}
else if (centerModel.center.Month2 == true)
{
centerModel.firstMonth = 2;
}
else if (centerModel.center.Month3 == true)
{
centerModel.firstMonth = 3;
}
else if (centerModel.center.Month4 == true)
{
centerModel.firstMonth = 4;
}
else if (centerModel.center.Month5 == true)
{
centerModel.firstMonth = 5;
}
else if (centerModel.center.Month6 == true)
{
centerModel.firstMonth = 6;
}
else if (centerModel.center.Month7 == true)
{
centerModel.firstMonth = 7;
}
else if (centerModel.center.Month8 == true)
{
centerModel.firstMonth = 8;
}
else if (centerModel.center.Month9 == true)
{
centerModel.firstMonth = 9;
}
if (centerModel.center.Month9 == true)
{
centerModel.LastMonth = 9;
}
else if (centerModel.center.Month8 == true)
{
centerModel.LastMonth = 8;
}
else if (centerModel.center.Month7 == true)
{
centerModel.LastMonth = 7;
}
else if (centerModel.center.Month6 == true)
{
centerModel.LastMonth = 6;
}
else if (centerModel.center.Month5 == true)
{
centerModel.LastMonth = 5;
}
else if (centerModel.center.Month4 == true)
{
centerModel.LastMonth = 4;
}
else if (centerModel.center.Month3 == true)
{
centerModel.LastMonth = 3;
}
else if (centerModel.center.Month2 == true)
{
centerModel.LastMonth = 2;
}
else if (centerModel.center.Month1 == true)
{
centerModel.LastMonth = 1;
}
else if (centerModel.center.Month12 == true)
{
centerModel.LastMonth = 12;
}
else if (centerModel.center.Month11 == true)
{
centerModel.LastMonth = 11;
}
else if (centerModel.center.Month10 == true)
{
centerModel.LastMonth = 10;
}
if (centerModel == null)
{
return(HttpNotFound());
}
if (type.SeeAccToCity == true)
{
var empid = Convert.ToInt32(Session["ID"]);
var emp = db.Employees.FirstOrDefault(x => x.id == empid);
if (emp.CityID != centerModel.center.Cityid)
{
return(RedirectToAction("Default", "Home"));
}
ViewBag.Periodid = new SelectList(db.Periods, "id", "Name", centerModel.center.Periodid);
ViewBag.Cityid = new SelectList(db.Cities.Where(x => x.id == emp.CityID), "id", "Name", centerModel.center.Cityid);
ViewBag.DependedOn = new SelectList(db.Centers.Where(x => x.Cityid == emp.CityID && x.CenterType == "رئيسي" && x.id != id), "id", "Name", centerModel.center.DependedOn);
}
else
{
ViewBag.Periodid = new SelectList(db.Periods, "id", "Name", centerModel.center.Periodid);
ViewBag.Cityid = new SelectList(db.Cities, "id", "Name", centerModel.center.Cityid);
ViewBag.DependedOn = new SelectList(db.Centers.Where(x => x.CenterType == "رئيسي" && x.id != id), "id", "Name", centerModel.center.DependedOn);
}
ViewBag.TitleSideBar = "Centers";
return(View(centerModel));
}
return(RedirectToAction("Default", "Home"));
}
return(RedirectToAction("Index", "Home"));
}
public ActionResult Edit(/*[Bind(Include = "id,Name,Place,Desc,State,HolesN,Cityid")]*/ CenterModel centerModel, IEnumerable <HttpPostedFileBase> file)
{
if (Session["ID"] == null)
{
return(RedirectToAction("Index", "Home"));
}
bool proceed = true;
if (ModelState.IsValid)
{
int prooveid;
try
{
prooveid = db.Prooves.OrderByDescending(x => x.id).FirstOrDefault().id + 1;
}
catch (Exception)
{
prooveid = 1;
}
try
{
if (file.Count() > 1 || file.Count() > 0 && file.FirstOrDefault() != null)
{
var oldImages = db.Prooves.Where(x => x.CenterID == centerModel.center.id).ToList();
foreach (var image in oldImages)
{
db.Prooves.Remove(image);
}
if ((Directory.Exists(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id)))
{
try
{
Directory.Delete(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id, true);
}
catch (IOException)
{
Directory.Delete(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id, true);
}
catch (UnauthorizedAccessException)
{
Directory.Delete(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id, true);
}
}
if (!Directory.Exists(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id))
{
Directory.CreateDirectory(Server.MapPath("~/App_Data/Centers") + "\\" + centerModel.center.id);
}
foreach (var item in file)
{
if (item.ContentLength > 0)
{
var fileName = Path.GetFileName(item.FileName);
var path = Path.Combine(Server.MapPath("~/App_Data/Centers/" + centerModel.center.id), fileName);
item.SaveAs(path);
Proove proove = new Proove();
proove.Path = path;
proove.id = prooveid;
proove.CenterID = centerModel.center.id;
db.Prooves.Add(proove);
prooveid++;
}
else
{
}
}
try
{
var startPath = Server.MapPath("~/App_Data/Centers" + "\\" + centerModel.center.id);
if (!Directory.Exists(Server.MapPath("~/App_Data/Centers" + "\\" + "ZipFolder")))
{
Directory.CreateDirectory(Server.MapPath("~/App_Data/Centers" + "\\" + "ZipFolder"));
}
var zipPath = Server.MapPath("~/App_Data/Centers" + "\\" + "ZipFolder") + "\\" + centerModel.center.id + ".zip";
if (System.IO.File.Exists(zipPath))
{
System.IO.File.Delete(zipPath);
}
try
{
ZipFile.CreateFromDirectory(startPath, zipPath);
}
catch { }
centerModel.center.Proof = zipPath;
}
catch { }
}
}
catch
{
}
db.SaveChanges();
if (centerModel.Cityid == null)
{
centerModel.center.Cityid = db.Centers.Find(centerModel.DependedOn).Cityid;
}
else
{
centerModel.center.Cityid = centerModel.Cityid;
}
centerModel.center.DependedOn = centerModel.DependedOn;
for (int i = 0; i <= 12; i++)
{
switch (i)
{
case 1:
centerModel.center.Month1 = false;
break;
case 2:
centerModel.center.Month2 = false;
break;
case 3:
centerModel.center.Month3 = false;
break;
case 4:
centerModel.center.Month4 = false;
break;
case 5:
centerModel.center.Month5 = false;
break;
case 6:
centerModel.center.Month6 = false;
break;
case 7:
centerModel.center.Month7 = false;
break;
case 8:
centerModel.center.Month8 = false;
break;
case 9:
centerModel.center.Month9 = false;
break;
case 10:
centerModel.center.Month10 = false;
break;
case 11:
centerModel.center.Month11 = false;
break;
case 12:
centerModel.center.Month12 = false;
break;
}
}
if (centerModel.firstMonth > centerModel.LastMonth)
{
for (int i = centerModel.firstMonth; i <= 12; i++)
{
switch (i)
{
case 10:
centerModel.center.Month10 = true;
break;
case 11:
centerModel.center.Month11 = true;
break;
case 12:
centerModel.center.Month12 = true;
break;
}
}
centerModel.firstMonth = 1;
}
for (int i = centerModel.firstMonth; i <= centerModel.LastMonth; i++)
{
switch (i)
{
case 1:
centerModel.center.Month1 = true;
break;
case 2:
centerModel.center.Month2 = true;
break;
case 3:
centerModel.center.Month3 = true;
break;
case 4:
centerModel.center.Month4 = true;
break;
case 5:
centerModel.center.Month5 = true;
break;
case 6:
centerModel.center.Month6 = true;
break;
case 7:
centerModel.center.Month7 = true;
break;
case 8:
centerModel.center.Month8 = true;
break;
case 9:
centerModel.center.Month9 = true;
break;
case 10:
centerModel.center.Month10 = true;
break;
case 11:
centerModel.center.Month11 = true;
break;
case 12:
centerModel.center.Month12 = true;
break;
}
}
if (proceed)
{
db.Entry(centerModel.center).State = EntityState.Modified;
db.SaveChanges();
TempData["Message"] = "تم التعديل بنجاح";
return(RedirectToAction("Index"));
}
}
var typeName = (string)Session["Type"]; var type = db.EmployeeTypes.Where(x => x.Type == typeName).FirstOrDefault();
if (type.SeeAccToCity == true)
{
var id = Convert.ToInt32(Session["ID"]);
var emp = db.Employees.Find(id);
ViewBag.Periodid = new SelectList(db.Periods, "id", "Name", centerModel.center.Periodid);
ViewBag.Cityid = new SelectList(db.Cities.Where(x => x.id == emp.CityID), "id", "Name", centerModel.center.Cityid);
ViewBag.DependedOn = new SelectList(db.Centers.Where(x => x.Cityid == emp.CityID && x.CenterType == "رئيسي" && x.id != centerModel.center.id), "id", "Name", centerModel.center.DependedOn);
}
else
{
ViewBag.Periodid = new SelectList(db.Periods, "id", "Name", centerModel.center.Periodid);
ViewBag.Cityid = new SelectList(db.Cities, "id", "Name", centerModel.center.Cityid);
ViewBag.DependedOn = new SelectList(db.Centers.Where(x => x.CenterType == "رئيسي" && x.id != centerModel.center.id), "id", "Name", centerModel.center.DependedOn);
}
ViewBag.TitleSideBar = "Centers";
return(View(centerModel));
}
