public ReferenceUniversalItemModel(ReferenceUniversalItem item)
{
ReferenceName = item.ReferenceName;
Id = item.Id;
Name = item.Name;
DisplayName = item.DisplayName;
Code = item.Code;
District = item.District;
SMO = item.SMO;
Address = item.Address;
Phone = item.Phone;
WorkHours = item.WorkHours;
IsDigitPolicyAbailable = item.IsDigitPolicyAbailable;
ParentId = item.ParentId;
StartDate = item.StartDate;
EndDate = item.EndDate;
IsEnabledForOperator = item.IsEnabledForOperator;
IsEnabledForRegistrator = item.IsEnabledForRegistrator;
IsMFC = item.IsMFC;
SendSms = item.SendSms;
DeliveryCenterId = item.DeliveryCenterId;
DeliveryPointHeadId = item.DeliveryPointHeadId;
LPU_ID_AIS = item.LPU_ID_AIS;
FIL_ID = item.FIL_ID;
MCOD = item.MCOD;
FULLNAME = item.FULLNAME;
OGRN = item.OGRN;
FCOD = item.FCOD;
Lastname = item.Lastname;
Firstname = item.Firstname;
Secondname = item.Secondname;
ErrCode = item.ErrCode;
}
public ReferenceUniversalItemModel(ReferenceUniversalItem item)
{
ReferenceName = item.ReferenceName;
Id = item.Id;
Name = item.Name;
DisplayName = item.DisplayName;
Code = item.Code;
//Lastname = item.Lastname;
//Firstname = item.Firstname;
//Secondname = item.Secondname;
}
public ActionResult ReferenceRefEdit(long?id, ReferenceUniversalItem model)
{
if (ReferenceUniversalItemModel.ListReferenceUniversalItem.Where(a => a.Id == id).Count() > 0)
{
//Update
referenceBusinessLogic.SaveUniversalReferenceItem(model, model.ReferenceName, false);
}
else
{
//Insert
referenceBusinessLogic.SaveUniversalReferenceItem(model, model.ReferenceName, true);
}
return(RedirectToAction(model.ReferenceName));
}
public void SaveUniversalReferenceItem(ReferenceUniversalItem item, string referenceName, bool flagUpdateOrInsert = false)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@ReferenceName", SqlDbType.NVarChar, referenceName);
parameters.AddInputParameter("@FlagUpdateOrInsert", SqlDbType.Bit, flagUpdateOrInsert);
parameters.AddInputParameter("@ID", SqlDbType.BigInt, item.Id);
parameters.AddInputParameter("@Name", SqlDbType.NVarChar, item.Name);
parameters.AddInputParameter("@DisplayName", SqlDbType.NVarChar, item.DisplayName);
parameters.AddInputParameter("@Code", SqlDbType.NVarChar, item.Code);
//parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, item.Lastname);
//parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, item.Firstname);
//parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, item.Secondname);
Execute_StoredProcedure("Reference_SaveItem", parameters);
}
public void SaveUniversalReferenceItem(ReferenceUniversalItem item, string referenceName, bool flagUpdateOrInsert = false)
{
List <SqlParameter> parameters = new List <SqlParameter>();
parameters.AddInputParameter("@ReferenceName", SqlDbType.NVarChar, referenceName);
parameters.AddInputParameter("@FlagUpdateOrInsert", SqlDbType.Bit, flagUpdateOrInsert);
parameters.AddInputParameter("@ID", SqlDbType.BigInt, item.Id);
parameters.AddInputParameter("@Name", SqlDbType.NVarChar, item.Name);
parameters.AddInputParameter("@DisplayName", SqlDbType.NVarChar, item.DisplayName);
parameters.AddInputParameter("@Code", SqlDbType.NVarChar, item.Code);
parameters.AddInputParameter("@District", SqlDbType.NVarChar, item.District);
parameters.AddInputParameter("@SMO", SqlDbType.NVarChar, item.SMO);
parameters.AddInputParameter("@Address", SqlDbType.NVarChar, item.Address);
parameters.AddInputParameter("@Phone", SqlDbType.NVarChar, item.Phone);
parameters.AddInputParameter("@WorkHours", SqlDbType.NVarChar, item.WorkHours);
parameters.AddInputParameter("@IsDigitPolicyAbailable", SqlDbType.Bit, item.IsDigitPolicyAbailable);
parameters.AddInputParameter("@ParentID", SqlDbType.BigInt, item.ParentId);
parameters.AddInputParameter("@IsEnabledForOperator", SqlDbType.Bit, item.IsEnabledForOperator);
parameters.AddInputParameter("@IsEnabledForRegistrator", SqlDbType.Bit, item.IsEnabledForRegistrator);
parameters.AddInputParameter("@IsMFC", SqlDbType.Bit, item.IsMFC);
parameters.AddInputParameter("@StartDate", SqlDbType.DateTime, item.StartDate);
parameters.AddInputParameter("@EndDate", SqlDbType.DateTime, item.EndDate);
parameters.AddInputParameter("@DeliveryCenterId", SqlDbType.BigInt, item.DeliveryCenterId);
parameters.AddInputParameter("@DeliveryPointHeadId", SqlDbType.BigInt, item.DeliveryPointHeadId);
parameters.AddInputParameter("@SendSms", SqlDbType.Bit, item.SendSms);
parameters.AddInputParameter("@LPU_ID_AIS", SqlDbType.BigInt, item.LPU_ID_AIS);
parameters.AddInputParameter("@FIL_ID", SqlDbType.BigInt, item.FIL_ID);
parameters.AddInputParameter("@MCOD", SqlDbType.NVarChar, item.MCOD);
parameters.AddInputParameter("@FULLNAME", SqlDbType.NVarChar, item.FULLNAME);
parameters.AddInputParameter("@OGRN", SqlDbType.NVarChar, item.OGRN);
parameters.AddInputParameter("@FCOD", SqlDbType.NVarChar, item.FCOD);
parameters.AddInputParameter("@Lastname", SqlDbType.NVarChar, item.Lastname);
parameters.AddInputParameter("@Firstname", SqlDbType.NVarChar, item.Firstname);
parameters.AddInputParameter("@Secondname", SqlDbType.NVarChar, item.Secondname);
parameters.AddInputParameter("@ErrCode", SqlDbType.NVarChar, item.ErrCode);
Execute_StoredProcedure("Reference_SaveItem", parameters);
}
/// <summary>
/// Сохраняем запись в справочник
/// </summary>
/// <param name="item"></param>
/// <param name="referenceName"></param>
/// <param name="flagUpdateOrInsert"></param>
public void SaveUniversalReferenceItem(ReferenceUniversalItem item, string referenceName, bool flagUpdateOrInsert = false)
{
ReferencesDao.Instance.SaveUniversalReferenceItem(item, referenceName, flagUpdateOrInsert);
}
