public async Task <IHttpActionResult> search(DAL.UserType model)
{
System.Web.HttpContext.Current.Application.Lock();
//var category = from m in _db.Categories select m;
var UserTypes = from ut in _db.UserTypes
select
new
{
UserTypeId = ut.UserTypeId,
UserTypeName = ut.UserTypeName,
status = ut.status
};
if (model.UserTypeName != null)
{
UserTypes = from ut in UserTypes where ut.UserTypeName.Contains(model.UserTypeName) select ut;
}
if (model.status != 0)
{
UserTypes = from ut in UserTypes where ut.status == model.status select ut;
}
UserTypes = from ut in UserTypes orderby ut.UserTypeName select ut;
System.Web.HttpContext.Current.Application.UnLock();
return(Json(UserTypes));
}
void UserSetup(BLL.FundMaster fm)
{
DAL.UserAccount ua = new DAL.UserAccount();
ua.LoginId = fm.UserId;
ua.UserName = fm.UserId;
ua.Password = fm.Password;
DAL.UserType ut = new DAL.UserType();
ut.TypeOfUser = BLL.DataKeyValue.Administrator_Key;
ut.FundMasterId = fm.Id;
ut.UserAccounts.Add(ua);
foreach (var utfd in DB.UserTypeFormDetails)
{
DAL.UserTypeDetail utd = new DAL.UserTypeDetail();
utd.UserTypeFormDetailId = utfd.Id;
utd.IsViewForm = true;
utd.AllowInsert = true;
utd.AllowUpdate = true;
utd.AllowDelete = true;
ut.UserTypeDetails.Add(utd);
}
DB.UserTypes.Add(ut);
DB.SaveChanges();
SetDataKeyValue(fm.Id, ut.TypeOfUser, ut.Id);
}
private BLL.UserType UserTypeDAL_BLL(DAL.UserType d)
{
BLL.UserType b = d.toCopy <BLL.UserType>(new BLL.UserType());
if (d != null)
{
b.UserTypeDetails = new ObservableCollection <BLL.UserTypeDetail>(d.UserTypeDetails.Select(x => UserTypeDetailDAL_BLL(x)).ToList());
b.Company = d.CompanyDetail.toCopy <BLL.CompanyDetail>(new BLL.CompanyDetail());
}
return(b);
}
private BLL.UserType UserTypeDAL_BLL(DAL.UserType d)
{
BLL.UserType b = d.toCopy <BLL.UserType>(new BLL.UserType());
if (d != null)
{
b.UserTypeDetails = new ObservableCollection <BLL.UserTypeDetail>(d.UserTypeDetails.Select(x => UserTypeDetailDAL_BLL(x)).ToList());
b.Fund = d.FundMaster.toCopy <BLL.FundMaster>(new BLL.FundMaster());
}
return(b);
}
public int userType_Save(BLL.UserType ut)
{
try
{
DAL.UserType d = DB.UserTypes.Where(x => x.Id == ut.Id).FirstOrDefault();
if (d == null)
{
var c = DB.CompanyDetails.Where(x => x.Id == ut.CompanyId).FirstOrDefault();
d = new DAL.UserType();
c.UserTypes.Add(d);
ut.toCopy <DAL.UserType>(d);
foreach (var utd in ut.UserTypeDetails)
{
d.UserTypeDetails.Add(utd.toCopy <DAL.UserTypeDetail>(new DAL.UserTypeDetail()));
}
DB.SaveChanges();
ut.Id = d.Id;
ut.Company = c.toCopy <BLL.CompanyDetail>(new BLL.CompanyDetail());
LogDetailStore(ut, LogDetailType.INSERT);
}
else
{
ut.toCopy <DAL.UserType>(d);
foreach (var utd in ut.UserTypeDetails)
{
DAL.UserTypeDetail dd = d.UserTypeDetails.Where(x => x.Id == utd.Id).FirstOrDefault();
if (dd == null)
{
dd = new DAL.UserTypeDetail();
d.UserTypeDetails.Add(dd);
}
utd.toCopy <DAL.UserTypeDetail>(dd);
}
DB.SaveChanges();
LogDetailStore(ut, LogDetailType.UPDATE);
}
Clients.Clients(OtherLoginClientsOnGroup).userType_Save(ut);
return(ut.Id);
}
catch (Exception ex) { }
return(0);
}
