public PSystemSetup()
{
InitializeComponent();
ClientSettingModel clientSettingModel = new ClientSettingModel();
clientSettingModel = settingsViewModel.GetClientSetting();
txtClientName.Text = clientSettingModel.ClientName;
txtAddress1.Text = clientSettingModel.Address1;
txtAddress2.Text = clientSettingModel.Address2;
txtEmail.Text = clientSettingModel.Email;
txtPhone.Text = clientSettingModel.Phone;
txtHeader.Text = clientSettingModel.Header;
txtFooter.Text = clientSettingModel.Footer;
txtFooter1.Text = clientSettingModel.Footer1;
txtFooter2.Text = clientSettingModel.Footer2;
txtFooter3.Text = clientSettingModel.Footer3;
txtFooter4.Text = clientSettingModel.Footer4;
txtWebsite.Text = clientSettingModel.Website;
txtOrderPrefix.Text = clientSettingModel.OrderPrefix;
txtReceiptPrefix.Text = clientSettingModel.ReceiptPrefix;
txtHeaderMarqueeText.Text = clientSettingModel.HeaderMarqueeText;
txtDeliveryList.Text = clientSettingModel.DeliveryList;
txtPowerby.Text = clientSettingModel.Powerby;
chkIsItemOverright.IsChecked = (bool)clientSettingModel.IsItemOverright;
txtLinkedServer.Text = clientSettingModel.LinkedServer;
txtWebAppUrl.Text = clientSettingModel.WebAppUrl;
txtCurrentOutletId.Text = clientSettingModel.CurrentOutletId;
txtInvoiceTerms.Text = clientSettingModel.InvoiceTerms;
}
public ActionResult ClientSetting()
{
ClientSettingModel settingModel = new ClientSettingModel();
string empCd = FormsAuthentication.Decrypt(Request.Cookies[FormsAuthentication.FormsCookieName].Value).Name;
//get the date of current month.
DateTime date = SystemClock.US_Date.Date;
DateTime startOfMonth = new DateTime(date.Year, date.Month, 1);
DateTime endOfMonth = new DateTime(date.Year, date.Month, DateTime.DaysInMonth(date.Year, date.Month));
endOfMonth.AddDays(1);
// get the old list
var selectdClient = unitOfWork.ClientSetting.Get(s => s.RC_EmpCd == empCd).FirstOrDefault();
//get the client list for the current month.
var clientListForUser = unitOfWork.RIC_Job_Report.Get_ClientList(empCd, startOfMonth, endOfMonth)
.ToList();
//initilize the selected client.
settingModel.SelectedClient = new List <string>();
if (selectdClient != null)
{
List <string> oldlist = JsonConvert.DeserializeObject <List <string> >(selectdClient.RC_ClientList);
// add the list to selected combo box and filter the strings not in clients list.
settingModel.SelectedClient = oldlist.Where(s => clientListForUser.Any(a => a == s));
}
// filter the selected client.
//get the list of clients for user where not in selected.
settingModel.ClientList = clientListForUser
.Where(s => !settingModel.SelectedClient.Any(a => a == s))
.ToList();
return(View(settingModel));
}
private void btnSave_Click(object sender, RoutedEventArgs e)
{
if (btnSave.Content.ToString() == "Edit")
{
btnSave.Content = "Save";
btnCancel.Visibility = Visibility.Visible;
txtClientName.IsEnabled = true;
txtAddress1.IsEnabled = true;
txtAddress2.IsEnabled = true;
txtEmail.IsEnabled = true;
txtPhone.IsEnabled = true;
txtHeader.IsEnabled = true;
txtFooter.IsEnabled = true;
txtFooter1.IsEnabled = true;
txtFooter2.IsEnabled = true;
txtFooter3.IsEnabled = true;
txtFooter4.IsEnabled = true;
txtWebsite.IsEnabled = true;
txtOrderPrefix.IsEnabled = true;
txtReceiptPrefix.IsEnabled = true;
txtHeaderMarqueeText.IsEnabled = true;
txtDeliveryList.IsEnabled = true;
txtPowerby.IsEnabled = true;
chkIsItemOverright.IsEnabled = true;
txtLinkedServer.IsEnabled = true;
txtWebAppUrl.IsEnabled = true;
txtCurrentOutletId.IsEnabled = true;
txtInvoiceTerms.IsEnabled = true;
}
else
{
ClientSettingModel clientSettingModel = new ClientSettingModel();
clientSettingModel.ClientName = txtClientName.Text;
clientSettingModel.Address1 = txtAddress1.Text;
clientSettingModel.Address2 = txtAddress2.Text;
clientSettingModel.Email = txtEmail.Text;
clientSettingModel.Phone = txtPhone.Text;
clientSettingModel.Header = txtHeader.Text;
clientSettingModel.Footer = txtFooter.Text;
clientSettingModel.Footer1 = txtFooter1.Text;
clientSettingModel.Footer2 = txtFooter2.Text;
clientSettingModel.Footer3 = txtFooter3.Text;
clientSettingModel.Footer4 = txtFooter4.Text;
clientSettingModel.Website = txtWebsite.Text;
clientSettingModel.OrderPrefix = txtOrderPrefix.Text;
clientSettingModel.ReceiptPrefix = txtReceiptPrefix.Text;
clientSettingModel.HeaderMarqueeText = txtHeaderMarqueeText.Text;
clientSettingModel.DeliveryList = txtDeliveryList.Text;
clientSettingModel.Powerby = txtPowerby.Text;
clientSettingModel.IsItemOverright = (bool)chkIsItemOverright.IsChecked;
clientSettingModel.LinkedServer = txtLinkedServer.Text;
clientSettingModel.WebAppUrl = txtWebAppUrl.Text;
clientSettingModel.CurrentOutletId = txtCurrentOutletId.Text;
clientSettingModel.InvoiceTerms = txtInvoiceTerms.Text;
var result = settingsViewModel.UpdateClientSetting(clientSettingModel);
btnCancel_Click(null, null);
}
}
public ClientSettingModel GetClientSetting()
{
ClientSettingModel clientSettingModel = new ClientSettingModel();
using (var connection = new SqlConnection(appSettings.GetConnectionString()))
{
connection.Open();
var query = " select ClientName,Address1,Address2,Email,Phone,Header,Footer,Footer1,Footer2,Footer3,Footer4,website,OrderPrefix,ReceiptPrefix, " +
" HeaderMarqueeText,DeliveryList,Powerby,IsItemOverright,LinkedServer,WebAppUrl,CurrentOutletId,InvoiceTerms from Client ";
clientSettingModel = connection.Query <ClientSettingModel>(query).FirstOrDefault();
}
return(clientSettingModel);
}
public bool UpdateClientSetting(ClientSettingModel clientSettingModel)
{
bool result = false;
int isItemOverright = 0;
if (clientSettingModel.IsItemOverright == false)
{
isItemOverright = 0;
}
else
{
isItemOverright = 1;
}
using (var connection = new SqlConnection(appSettings.GetConnectionString()))
{
var query = "Update [Client] set ClientName='" + clientSettingModel.ClientName + "'," +
"Address1 = '" + clientSettingModel.Address1 + "'," +
"Address2 = '" + clientSettingModel.Address2 + "'," +
"Email = '" + clientSettingModel.Email + "'," +
"Phone = '" + clientSettingModel.Phone + "'," +
"Header = '" + clientSettingModel.Header + "'," +
"Footer = '" + clientSettingModel.Footer + "'," +
"Footer1 = '" + clientSettingModel.Footer1 + "'," +
"Footer2 = '" + clientSettingModel.Footer2 + "'," +
"Footer3 = '" + clientSettingModel.Footer3 + "'," +
"Footer4 = '" + clientSettingModel.Footer4 + "'," +
"website = '" + clientSettingModel.Website + "'," +
"OrderPrefix = '" + clientSettingModel.OrderPrefix + "'," +
"ReceiptPrefix = '" + clientSettingModel.ReceiptPrefix + "'," +
"HeaderMarqueeText = '" + clientSettingModel.HeaderMarqueeText + "'," +
"DeliveryList = '" + clientSettingModel.DeliveryList + "'," +
"Powerby = '" + clientSettingModel.Powerby + "'," +
"IsItemOverright = " + isItemOverright + "," +
"LinkedServer = '" + clientSettingModel.LinkedServer + "'," +
"WebAppUrl = '" + clientSettingModel.WebAppUrl + "'," +
"InvoiceTerms='" + clientSettingModel.InvoiceTerms + "'," +
"CurrentOutletId = " + clientSettingModel.CurrentOutletId;
result = connection.Query <bool>(query).FirstOrDefault();
}
return(result);
}
public static IEnumerable <Client> GetClients(ClientSettingModel option)
{
return(new List <Client>
{
new Client
{
ClientId = option.ClientCredential_Anna.ClientId,
ClientName = option.ClientCredential_Anna.ClientName,
AllowedGrantTypes = GrantTypes.ClientCredentials,
ClientSecrets =
{
new Secret(option.ClientCredential_Anna.Secret.Sha256())
},
AllowedScopes = option.ClientCredential_Anna.Scopes
},
new Client
{
ClientId = option.ResourceOwner_Anabel.ClientId,
ClientName = option.ResourceOwner_Anabel.ClientName,
AllowedGrantTypes = GrantTypes.ResourceOwnerPassword,
ClientSecrets =
{
new Secret(option.ResourceOwner_Anabel.Secret.Sha256())
},
AllowedScopes = option.ResourceOwner_Anabel.Scopes,
AllowOfflineAccess = true,
UpdateAccessTokenClaimsOnRefresh = true
},
new Client
{
ClientId = option.Hybrid_Alexa.ClientId,
ClientName = option.Hybrid_Alexa.ClientName,
AllowedGrantTypes = GrantTypes.Hybrid,
ClientSecrets =
{
new Secret(option.Hybrid_Alexa.Secret.Sha256())
},
RedirectUris = option.Hybrid_Alexa.RedirectUris,
PostLogoutRedirectUris = option.Hybrid_Alexa.PostLogoutRedirectUris,
AlwaysIncludeUserClaimsInIdToken = true,
AllowedScopes = option.Hybrid_Alexa.Scopes,
AllowOfflineAccess = true,
UpdateAccessTokenClaimsOnRefresh = true,
RequireConsent = false
},
new Client
{
ClientId = option.AuthCode_Amber.ClientId,
ClientName = option.AuthCode_Amber.ClientName,
AllowedGrantTypes = GrantTypes.Code,
ClientSecrets =
{
new Secret(option.AuthCode_Amber.Secret.Sha256())
},
RedirectUris = option.AuthCode_Amber.RedirectUris,
PostLogoutRedirectUris = option.AuthCode_Amber.PostLogoutRedirectUris,
AllowedScopes = option.AuthCode_Amber.Scopes,
AllowOfflineAccess = true,
UpdateAccessTokenClaimsOnRefresh = true,
RequireConsent = false
}
});
}
