public ActionResult Signup(Signup signupModel)
{
using (manageCallsEntities2 Db = new manageCallsEntities2())
{
if (Db.users.Any(x => x.userName == signupModel.username))
{
ViewBag.DuplicateMessage = "username already exist";
return(View("Signup", signupModel));
}
user u = new user
{
userName = signupModel.username,
password = signupModel.password,
familyName = signupModel.familyName,
nationalCode = signupModel.nationalityCode,
name = signupModel.name,
email = signupModel.email,
gender = signupModel.gender,
accepted = true,
createDate = DateTime.Now
};
Db.users.Add(u);
Db.SaveChanges();
}
ModelState.Clear();
ViewBag.SuccessMessage = "successful";
return(View("Signup", new Signup()));
}
//---------------------------------فیلتر کردن گزارش ها---------------------//
public static List <view_rawReports> shownReport(string lastName, string number, string chosenRole, DateTime startDate, DateTime finishDate, TimeSpan?duration)
{
var db = new manageCallsEntities2();
var report = from v in db.view_rawReports
where v.callDate >= startDate &&
v.callDate <= finishDate
select v;
if (String.IsNullOrEmpty(lastName) == false)// بر اساس نام خانوادگی
{
report = report.Where(r => r.familyName.Contains(lastName));
}
if (number != null)//بر اساس شماره داخلی
{
report = report.Where(r => r.number.Equals(number));
}
if (String.IsNullOrEmpty(chosenRole) == false)//براساس نقش انتخابی
{
report = report.Where(r => r.roleName.Contains(chosenRole));
}
if (duration != null)//کاربران مشکوک
{
report = report.Where(r => r.callDuration >= duration);
}
return(report.ToList());
}
//------------------------افزودن نقش جدید----------------------//
public static bool addNewRole(int unitID, string newRoleName)
{
manageCallsEntities2 db = new manageCallsEntities2();
bool result = false;
try
{
if (db.roles.Any(p => p.roleName.Equals(newRoleName)))
{
return(result);
}
else
{
role newRole = new role();
newRole.roleName = newRoleName;
db.roles.Add(newRole);
db.SaveChanges();
result = true;
}
}
catch
{
return(result);
}
return(result);
}
//بعنوان ورودی بازه ی ماه را میگیرد
//در نهایت این متد تاریخ های بین بازه ی مشخص شده را برمیگرداند
public static object date(int monDuration)
{
manageCallsEntities2 db = new manageCallsEntities2();
string thisYear = (DateTime.Now.Year).ToString(); // امسال
string thisMonth = (DateTime.Now.Month).ToString(); // ماه جاری
string today = (DateTime.Now.Day).ToString(); // امروز
var todayDate = Convert.ToInt32(thisYear + thisMonth + today); //تاریخ امروز
var lastMon = (Convert.ToInt16(thisMonth) - monDuration); //ماه گذشته
var lastYear = thisYear;
if (lastMon == 0)
{
lastMon = 12;
lastYear = (Convert.ToInt16(thisYear) - monDuration).ToString();//سال گذشته
}
var lastMonDate = Convert.ToInt32(lastYear + lastMon + today);//تاریخ بازه ی انتخابی
//لیست گزارش تماس تمام افراد در بازه ی مشخص شده
var report = from d in db.calls
where d.callDate.Month >= lastMonDate
select d;
return(report);
}
public ActionResult Login(Login userLogin)
{
List <user> query = null;
using (manageCallsEntities2 db = new manageCallsEntities2())
{
query = (from y in db.users
where (y.userName == userLogin.username && y.password == userLogin.password)
select y).ToList();
}
if (query.Count != 0)
{
return(RedirectToAction("index", "AdminViewCalls"));
}
else
{
ViewBag.SuccessMessage = "تلاش مجدد ";
return(View("Login", new Login()));
}
}
//-----------------افزودن کاربر جدید-----------------//
public static bool addNewUser(Array[] userInfo, int _unitID, int _roleID)
{
manageCallsEntities2 db = new manageCallsEntities2();
bool result = false;//نتیجه ی عملیات
bool gender;
var userName = userInfo[0].ToString();
var firstName = userInfo[1].ToString();
var lastName = userInfo[2].ToString();
string nationalCode = userInfo[3].ToString();
var email = userInfo[4].ToString();
/* تعیین نقش و واحد :/ */
//تعیین جنسیت
try
{
if (Convert.ToInt16(userInfo[5]) == 0)//female
{
gender = true;
}
else //male
{
gender = false;
}
}
catch
{
return(result);
}
//بررسی عدم تکراری بودن کاربر
try
{
var existUser = db.users.FirstOrDefault(p => p.nationalCode.Equals(nationalCode));
if (existUser == null)
{
return(result);
}
//اضافه کردن کاربر
else
{
//اضافه کردن به جدول کاربران
user newUser = new user();
newUser.userName = userName;
newUser.name = firstName;
newUser.familyName = lastName;
newUser.nationalCode = nationalCode;
newUser.email = email;
newUser.gender = gender;
newUser.accepted = true;
db.users.Add(newUser);
db.SaveChanges();
//اضافه کردن به جدول roleinunit
roleInUnit newRoleInUnit = new roleInUnit();
newRoleInUnit.role_id = _roleID;
newRoleInUnit.unit_id = _unitID;
newRoleInUnit.user_id = newUser.id;
db.roleInUnits.Add(newRoleInUnit);
db.SaveChanges();
result = true;
}
}
catch
{
return(result);
}
return(result);
}
