public int Delete(CustomerContact_VM Model)
{
int result = 0;
try
{
using (var db = new DBConnection())
{
var par = new SqlParameter[] {
new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID)),
new SqlParameter("@p_ContactName", GetDBNULLString(Model.ContactName)),
new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.CurrentLanguageCode)),
new SqlParameter("@p_UTCOffset", GetDBNULL(Model.CurrentUTCOffset)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint))
};
result = db.ExecuteNonQueryRollBack("DeleteCustomerContact", par);
}
}
catch (Exception ex)
{
logger.Error("CustomerContactRepository_Delete: ", ex);
throw;
}
return(result);
}
public List <CustomerContact_VM> GetData(CustomerContact_VM Model)
{
List <CustomerContact_VM> query = new List <CustomerContact_VM>();
try
{
using (var db = new WebPortalEntities())
{
var config = new MapperConfiguration(cfg => cfg.CreateMap <GetCustomerContact_Result, CustomerContact_VM>());
var mapper = config.CreateMapper();
List <GetCustomerContact_Result> data = db.GetCustomerContact(Model.CustomerID, Model.ContactName,
Model.Email, Model.Telephone, Model.Mobile, Model.IsPrimaryContact, Model.CurrentLanguageCode,
Model.CurrentUTCOffset, Model.CurrentEndUserID, Model.CurrentUserRoleID, Model.CurrentScreenID, Model.AccessPoint).ToList();
mapper.Map <List <GetCustomerContact_Result>, List <CustomerContact_VM> >(data, query);
}
if (query.Count > 0)
{
if (query[0].UserID != null && Model.IsChildResult == true)
{
var customerContact = query[0];
UserRepository user_ = new UserRepository();
var CustomerContactUser = user_.GetData(new EndUser_VM()
{
EndUserID = customerContact.UserID, IsChildResult = true, IsCustomerUser = true
});
if (CustomerContactUser.Count > 0)
{
var _CustomerContactUser = CustomerContactUser[0];
customerContact.IsWebAccess = true;
customerContact.LanguageCode = _CustomerContactUser.LanguageCode;
customerContact.Gender = _CustomerContactUser.Gender;
customerContact.UTCOffset = _CustomerContactUser.UTCOffset;
customerContact.DefaultModuleCode = _CustomerContactUser.DefaultModuleCode;
customerContact.EndUserModuleList = _CustomerContactUser.EndUserModuleList;
customerContact.UserRoleUserList = _CustomerContactUser.UserRoleUserList;
}
}
}
}
catch (Exception ex)
{
logger.Error("CustomerContactRepository_GetData Error: ", ex);
throw;
}
return(query);
}
public int Update(CustomerContact_VM Model)
{
int result = 0;
try
{
var dt_EndUserModule = new DataTable();
if (Model.EndUserModule_TableTypeList != null && Model.EndUserModule_TableTypeList.Count > 0)
{
dt_EndUserModule = ConvertToDatatable(Model.EndUserModule_TableTypeList);
}
else
{
dt_EndUserModule = ConvertToDatatable(new List <EndUserModule_TableType_VM>());
}
var dt_UserRoleUser = new DataTable();
if (Model.UserRoleUser_TableTypeList != null && Model.UserRoleUser_TableTypeList.Count > 0)
{
dt_UserRoleUser = ConvertToDatatable(Model.UserRoleUser_TableTypeList);
}
else
{
dt_UserRoleUser = ConvertToDatatable(new List <UserRoleUser_TableType_VM>());
}
using (var db = new DBConnection())
{
var par = new SqlParameter[] {
new SqlParameter("@p_CustomerID", GetDBNULL(Model.CustomerID)),
new SqlParameter("@p_ContactName", GetDBNULLString(Model.ContactName)),
new SqlParameter("@p_ContactNameOld", GetDBNULLString(Model.ContactNameOld)),
new SqlParameter("@p_Email", GetDBNULLString(Model.Email)),
new SqlParameter("@p_Telephone", GetDBNULL(Model.Telephone)),
new SqlParameter("@p_Mobile", GetDBNULL(Model.Mobile)),
new SqlParameter("@p_IsPrimaryContact", GetDBNULL(Model.IsPrimaryContact)),
new SqlParameter("@p_IsWebAccess", GetDBNULL(Model.IsWebAccess)),
new SqlParameter("@p_UserID", GetDBNULL(Model.UserID)),
new SqlParameter("@p_CustomerContactLanguageCode", GetDBNULL(Model.LanguageCode)),
new SqlParameter("@p_CustomerContactUTCOffset", GetDBNULL(Model.UTCOffset)),
new SqlParameter("@p_DefaultModuleCode", GetDBNULL(Model.DefaultModuleCode)),
new SqlParameter("@p_Gender", GetDBNULL(Model.Gender)),
new SqlParameter("@p_UserIdentity", GetDBNULL(Model.UserIdentity)),
new SqlParameter("@p_EndUserModule", dt_EndUserModule)
{
TypeName = "EndUserModule_TableType"
},
new SqlParameter("@p_UserRoleUser", dt_UserRoleUser)
{
TypeName = "UserRoleUser_TableType"
},
new SqlParameter("@p_LanguageCode", GetDBNULLString(Model.CurrentLanguageCode)),
new SqlParameter("@p_UTCOffset", GetDBNULL(Model.CurrentUTCOffset)),
new SqlParameter("@p_EndUserID", GetDBNULL(Model.CurrentEndUserID)),
new SqlParameter("@p_UserRoleID", GetDBNULL(Model.CurrentUserRoleID)),
new SqlParameter("@p_ScreenID", GetDBNULL(Model.CurrentScreenID)),
new SqlParameter("@p_AccessPoint", GetDBNULLString(Model.AccessPoint))
};
result = db.ExecuteNonQueryRollBack("UpdateCustomerContact", par);
}
}
catch (Exception ex)
{
logger.Error("CustomerContactRepository_Update: ", ex);
throw;
}
return(result);
}
