/// <summary>
/// Function to fill the Dates
/// </summary>
public void FinancialYearDate()
{
try
{
dtpFromDate.MinDate = PublicVariables._dtFromDate;
dtpFromDate.MaxDate = PublicVariables._dtToDate;
CompanyInfo infoComapany = new CompanyInfo();
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
infoComapany = bllCompanyCreation.CompanyView(1);
DateTime dtFromDate = infoComapany.CurrentDate;
dtpFromDate.Value = dtFromDate;
txtFromDate.Text = dtFromDate.ToString("dd-MMM-yyyy");
dtpFromDate.Value = Convert.ToDateTime(txtFromDate.Text);
dtpToDate.MinDate = PublicVariables._dtFromDate;
dtpToDate.MaxDate = PublicVariables._dtToDate;
infoComapany = bllCompanyCreation.CompanyView(1);
DateTime dtToDate = infoComapany.CurrentDate;
dtpToDate.Value = dtToDate;
dtpToDate.Text = dtToDate.ToString("dd-MMM-yyyy");
dtpToDate.Value = Convert.ToDateTime(txtFromDate.Text);
}
catch (Exception ex)
{
MessageBox.Show("JREG4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public CompanyInfo GetCompanyInfo(string recuiterId)
{
CompanyInfo companyInfo = new CompanyInfo();
if (recuiterId != null)
{
companyInfo = this.CompanyInfoRepository.Get(s => s.RecruiterID == recuiterId).FirstOrDefault();
}
return companyInfo;
}
public static CompanyInfo Get(string OrgAlias, string InstAlias, Guid OrgGuid, Guid InstGuid)
{
lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext dc = lib.bwa.bigWebDesk.LinqBll.Context.MutiBaseDataContext.Create(OrgAlias, InstAlias, OrgGuid, InstGuid);
CompanyInfo ret = new CompanyInfo();
if (dc == null || dc.OrganizationId==null || dc.OrganizationId==Guid.Empty) return ret;
if (dc.InstaceId != null) ret.InstanceId = (Guid)dc.InstaceId;
ret.OrganizationId = (Guid)dc.OrganizationId;
if (dc.DepartmentId!=null) ret.DepartmentId = (int)dc.DepartmentId;
return ret;
}
public ActionResult Contact()
{
var companyInfo = new CompanyInfo
{
CompanyName = "Your company name here",
AddressLine1 = "Company address Line 1",
AddressLine2 = "Company address Line 2",
City = "City",
State = "State",
Zip = "00000",
Email = "*****@*****.**"
};
return View(companyInfo);
}
/// <summary>
/// Function to do after company creation
/// </summary>
public void AfterCompanyCreation()
{
try
{
PublicVariables._decCurrentUserId = 1;
formMDI.MDIObj.CallFromLogin();
formMDI.MDIObj.ShowQuickLaunchMenu();
frmNewFinancialYear frmNewFinancialYearObj = new frmNewFinancialYear();
frmNewFinancialYearObj.MdiParent = formMDI.MDIObj;
frmNewFinancialYearObj.CallFromCompanyCreation(this);
CompanyInfo infoCompany = new CompanyInfo();
CompanyCreationBll BllCompanyCreation = new CompanyCreationBll();
infoCompany = BllCompanyCreation.CompanyView(1);
PublicVariables._decCurrencyId = infoCompany.CurrencyId;
}
catch (Exception ex)
{
MessageBox.Show("CR11:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public override void StoreTvNetworkMatch(CompanyInfo company)
{
}
public bool ValidUpdateObject(CompanyInfo companyInfo, ICompanyInfoService _companyInfoService)
{
companyInfo.Errors.Clear();
return(ValidCreateObject(companyInfo, _companyInfoService));
}
private void VerifyData(ApiResponse <HrbcCoreTmpCompanyInfoResponse> response, ValidTestCases inputType, CompanyInfo companyInfo)
{
var creds = AuthenticationInfoProvider.GetAuthSpecForCurrentTest();
var adminName = creds.Companies.First().Value.Users.First().Metadata["name"].ToString();
creds.Dispose();
if (inputType == ValidTestCases.Default || inputType == ValidTestCases.False)
{
PrAssert.That(response.Result.Name, PrIs.Null);
}
else
{
PrAssert.That(response.Result.Name, PrIs.EqualTo(companyInfo.Name));
}
PrAssert.That(response.Result.CompanyLoginId, PrIs.EqualTo(companyInfo.CompanyLoginId));
PrAssert.That(response.Result.CatalogName, PrIs.EqualTo(companyInfo.CatalogName));
PrAssert.That(response.Result.DbInfoHost, PrIs.EqualTo(companyInfo.DbInfoHost));
PrAssert.That(response.Result.DbInfoPort, PrIs.EqualTo(companyInfo.DbInfoPort));
PrAssert.That(response.Result.DbInfoUserName, PrIs.EqualTo(companyInfo.DbInfoUserName));
PrAssert.That(response.Result.DbInfoPassword, PrIs.EqualTo(companyInfo.DbInfoPassword));
PrAssert.That(response.Result.Id, PrIs.EqualTo(companyInfo.Id));
}
public override bool GetFanArt <T>(T infoObject, string language, string fanartMediaType, out ApiWrapperImageCollection <FanArtMovieThumb> images)
{
images = new ApiWrapperImageCollection <FanArtMovieThumb>();
try
{
if (fanartMediaType == FanArtMediaTypes.Movie)
{
FanArtMovieThumbs imgs = null;
MovieInfo movie = infoObject as MovieInfo;
if (movie != null && movie.MovieDbId > 0)
{
// Download all image information, filter later!
imgs = _fanArtTvHandler.GetMovieThumbs(movie.MovieDbId.ToString());
}
if (imgs != null)
{
images.Id = movie.MovieDbId.ToString();
if (imgs.MovieFanArt != null)
{
images.Backdrops.AddRange(imgs.MovieFanArt.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.MovieBanners != null)
{
images.Banners.AddRange(imgs.MovieBanners.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.MoviePosters != null)
{
images.Posters.AddRange(imgs.MoviePosters.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.MovieCDArt != null)
{
images.DiscArt.AddRange(imgs.MovieCDArt.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.HDMovieClearArt != null)
{
images.ClearArt.AddRange(imgs.HDMovieClearArt.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.HDMovieLogos != null)
{
images.Logos.AddRange(imgs.HDMovieLogos.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.MovieThumbnails != null)
{
images.Thumbnails.AddRange(imgs.MovieThumbnails.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
return(true);
}
}
else if (fanartMediaType == FanArtMediaTypes.Series)
{
FanArtTVThumbs imgs = null;
EpisodeInfo episode = infoObject as EpisodeInfo;
SeasonInfo season = infoObject as SeasonInfo;
SeriesInfo series = infoObject as SeriesInfo;
if (series == null && season != null)
{
series = season.CloneBasicInstance <SeriesInfo>();
}
if (series == null && episode != null)
{
series = episode.CloneBasicInstance <SeriesInfo>();
}
if (series != null && series.TvdbId > 0)
{
// Download all image information, filter later!
imgs = _fanArtTvHandler.GetSeriesThumbs(series.TvdbId.ToString());
}
if (imgs != null)
{
images.Id = series.TvdbId.ToString();
if (imgs.SeriesFanArt != null)
{
images.Backdrops.AddRange(imgs.SeriesFanArt.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.SeriesBanners != null)
{
images.Banners.AddRange(imgs.SeriesBanners.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.SeriesPosters != null)
{
images.Posters.AddRange(imgs.SeriesPosters.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.HDSeriesClearArt != null)
{
images.ClearArt.AddRange(imgs.HDSeriesClearArt.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.HDSeriesLogos != null)
{
images.Logos.AddRange(imgs.HDSeriesLogos.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.SeriesThumbnails != null)
{
images.Thumbnails.AddRange(imgs.SeriesThumbnails.OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
return(true);
}
}
else if (fanartMediaType == FanArtMediaTypes.SeriesSeason)
{
FanArtTVThumbs imgs = null;
int seasonNo = 0;
EpisodeInfo episode = infoObject as EpisodeInfo;
SeasonInfo season = infoObject as SeasonInfo;
if (season == null && episode != null)
{
season = episode.CloneBasicInstance <SeasonInfo>();
}
if (season != null && season.SeriesTvdbId > 0 && season.SeasonNumber.HasValue)
{
// Download all image information, filter later!
imgs = _fanArtTvHandler.GetSeriesThumbs(season.SeriesTvdbId.ToString());
seasonNo = season.SeasonNumber.Value;
}
if (imgs != null)
{
images.Id = season.SeriesTvdbId.ToString();
if (imgs.SeasonBanners != null)
{
images.Banners.AddRange(imgs.SeasonBanners.FindAll(b => !b.Season.HasValue || b.Season == seasonNo).
OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.SeasonPosters != null)
{
images.Posters.AddRange(imgs.SeasonPosters.FindAll(b => !b.Season.HasValue || b.Season == seasonNo).
OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
if (imgs.SeasonThumbnails != null)
{
images.Thumbnails.AddRange(imgs.SeasonThumbnails.FindAll(b => !b.Season.HasValue || b.Season == seasonNo).
OrderBy(b => string.IsNullOrEmpty(b.Language)).ThenByDescending(b => b.Likes).ToList());
}
return(true);
}
}
else if (fanartMediaType == FanArtMediaTypes.Artist)
{
FanArtArtistThumbs imgs = null;
PersonInfo person = infoObject as PersonInfo;
if (person != null && !string.IsNullOrEmpty(person.MusicBrainzId))
{
// Download all image information, filter later!
imgs = _fanArtTvHandler.GetArtistThumbs(person.MusicBrainzId);
}
if (imgs != null)
{
images.Id = person.MusicBrainzId;
if (imgs.ArtistFanart != null)
{
images.Backdrops.AddRange(imgs.ArtistFanart.OrderByDescending(b => b.Likes).Select(b => new FanArtMovieThumb(b)).ToList());
}
if (imgs.ArtistBanners != null)
{
images.Banners.AddRange(imgs.ArtistBanners.OrderByDescending(b => b.Likes).Select(b => new FanArtMovieThumb(b)).ToList());
}
if (imgs.HDArtistLogos != null)
{
images.Logos.AddRange(imgs.HDArtistLogos.OrderByDescending(b => b.Likes).Select(b => new FanArtMovieThumb(b)).ToList());
}
if (imgs.ArtistThumbnails != null)
{
images.Thumbnails.AddRange(imgs.ArtistThumbnails.OrderByDescending(b => b.Likes).Select(b => new FanArtMovieThumb(b)).ToList());
}
return(true);
}
}
else if (fanartMediaType == FanArtMediaTypes.MusicLabel)
{
FanArtLabelThumbs imgs = null;
CompanyInfo company = infoObject as CompanyInfo;
if (company != null && !string.IsNullOrEmpty(company.MusicBrainzId))
{
// Download all image information, filter later!
imgs = _fanArtTvHandler.GetLabelThumbs(company.MusicBrainzId);
}
if (imgs != null)
{
images.Id = company.MusicBrainzId;
if (imgs.LabelLogos != null)
{
images.Logos.AddRange(imgs.LabelLogos.OrderByDescending(b => b.Likes).Select(b => new FanArtMovieThumb(b)).ToList());
}
return(true);
}
}
else if (fanartMediaType == FanArtMediaTypes.Album)
{
FanArtAlbumDetails imgs = null;
string albumId = null;
TrackInfo track = infoObject as TrackInfo;
AlbumInfo album = infoObject as AlbumInfo;
if (album == null && track != null)
{
album = track.CloneBasicInstance <AlbumInfo>();
}
if (album != null && !string.IsNullOrEmpty(album.MusicBrainzGroupId))
{
// Download all image information, filter later!
imgs = _fanArtTvHandler.GetAlbumThumbs(album.MusicBrainzGroupId);
albumId = album.MusicBrainzGroupId;
}
if (imgs != null)
{
images.Id = albumId;
if (imgs.Albums != null && imgs.Albums.ContainsKey(albumId) && imgs.Albums[albumId].AlbumCovers != null)
{
images.Covers.AddRange(imgs.Albums[albumId].AlbumCovers.OrderByDescending(b => b.Likes).Select(b => new FanArtMovieThumb(b)).ToList());
}
if (imgs.Albums != null && imgs.Albums.ContainsKey(albumId) && imgs.Albums[albumId].CDArts != null)
{
images.DiscArt.AddRange(imgs.Albums[albumId].CDArts.OrderByDescending(b => b.Likes).Select(b => new FanArtMovieThumb(b)).ToList());
}
return(true);
}
}
else
{
return(true);
}
}
catch (Exception ex)
{
ServiceRegistration.Get <ILogger>().Debug(GetType().Name + ": Exception downloading images", ex);
}
return(false);
}
/// <summary>
/// Function to fill controls for Update
/// </summary>
public void CompanyViewForEdit()
{
try
{
isEditMode = true;
this.Text = "Edit Company";
btnSave.Text = "Update";
btnDelete.Enabled = true;
gbxDetails.Visible = false;
txtAdminUserName.ReadOnly = true;
txtAdminUserName.BackColor = Color.White;
cmbCurrency.Enabled = false;
CompanyCreationBll BllCompanyCreation = new CompanyCreationBll();
CompanyInfo infoCompany = new CompanyInfo();
decimal decCompanyId = 1;
infoCompany = BllCompanyCreation.CompanyView(PublicVariables._decCurrentCompanyId);
txtCompanyName.Text = infoCompany.CompanyName;
txtMailingName.Text = infoCompany.MailingName;
txtAddress.Text = infoCompany.Address;
txtPhoneNo.Text = infoCompany.Phone;
txtMobile.Text = infoCompany.Mobile;
txtEmail.Text = infoCompany.EmailId;
txtWeb.Text = infoCompany.Web;
txtCountry.Text = infoCompany.Country;
txtState.Text = infoCompany.State;
txtPincode.Text = infoCompany.Pin;
cmbCurrency.SelectedValue = infoCompany.CurrencyId;
txtFinancialYearFrom.Text = infoCompany.FinancialYearFrom.ToString("dd-MMM-yyyy");
dtpFinancialYearFrom.Text = infoCompany.FinancialYearFrom.ToString();
txtBooksBegining.Text = infoCompany.BooksBeginingFrom.ToString("dd-MMM-yyyy");
dtpBooksBegining.Text = infoCompany.BooksBeginingFrom.ToString();
txtTinNo.Text = infoCompany.Tin;
txtCstNo.Text = infoCompany.Cst;
txtPanNo.Text = infoCompany.Pan;
logo = (byte[])infoCompany.Logo;
MemoryStream ms = new MemoryStream(logo);
Image newimage = Image.FromStream(ms);
pbxLogo.Image = newimage;
pbxLogo.SizeMode = PictureBoxSizeMode.StretchImage;
CompanyPathInfo infoCompanyPath = new CompanyPathInfo();
CompanyPathBll BllComapnyPath = new CompanyPathBll();
infoCompanyPath = BllComapnyPath.CompanyPathView(1);
if (infoCompanyPath.IsDefault == true)
{
cbxSetAsDefault.Checked = true;
}
else
{
cbxSetAsDefault.Checked = false;
}
UserBll bllUser = new UserBll();
UserInfo infoUser = new UserInfo();
decimal decuserId = PublicVariables._decCurrentUserId;
infoUser = bllUser.UserView(decuserId);
txtAdminUserName.Text = infoUser.UserName;
txtPassword.Text = infoUser.Password;
txtRetypePassword.Text = infoUser.Password;
}
catch (Exception ex)
{
MessageBox.Show("CR8:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public static CompanyInfo GetAllCompanyByTradeId(int tradeId)
{
CompanyInfo currentData = new CompanyInfo();
//CompanyHelper_Update company = new CompanyHelper_Update();
//currentData.RecordCount = company.Select_Count_TradeCenter("", -1, tradeId, (int)FilterType.NoFilter);
//currentData.PageIndex = 1;
//currentData.PageCount = 1;
//using (DataTable dtCompanies = company.GetTradeCenter(tradeId.ToString()))
//{
// List<CompanyInfoItem> items = new List<CompanyInfoItem>();
// if (dtCompanies != null)
// {
// using (DataTable dtCompaniesIncludePrice = GetOnlineInfo(dtCompanies))
// {
// for (int i = 0; i < dtCompaniesIncludePrice.Rows.Count; i++)
// {
// if (Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["CurrentPrice"]) == 0)
// {
// items.Add(new CompanyInfoItem(dtCompaniesIncludePrice.Rows[i]["StockSymbol"].ToString(),
// dtCompaniesIncludePrice.Rows[i]["Fullname"].ToString(),
// dtCompaniesIncludePrice.Rows[i]["Symbol"].ToString(),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["BasicPrice"]),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["PE"]),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["EPS"])
// ));
// }
// else
// {
// items.Add(new CompanyInfoItem(dtCompaniesIncludePrice.Rows[i]["StockSymbol"].ToString(),
// dtCompaniesIncludePrice.Rows[i]["Fullname"].ToString(),
// dtCompaniesIncludePrice.Rows[i]["Symbol"].ToString(),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["CurrentPrice"]),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["PE"]),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["EPS"])
// )
// );
// }
// }
// }
// }
// currentData.CompanyInfos = items.ToArray();
//}
var items = new List<CompanyInfoItem>();
var key = tradeId > 0 ? string.Format(RedisKey.KeyStockListByCenter, tradeId): RedisKey.KeyStockList;
var sds = BLFACTORY.RedisClient.Get<List<StockCompact>>(key);
var ss = new List<string>();
foreach (var sym in sds)
{
ss.Add(sym.Symbol);
}
var infos = StockBL.GetStockCompactInfoMultiple(ss);
var prices = StockBL.GetStockPriceMultiple(ss);
foreach (var sym in sds)
{
var item = new CompanyInfoItem();
item.Symbol = sym.Symbol;
item.TradeCenter = Utils.GetCenterName(sym.TradeCenterId.ToString());
if(prices.ContainsKey(sym.Symbol))
{
var price = prices[sym.Symbol];
if(price!=null)
{
item.Price = price.Price;
}
}
if(infos.ContainsKey(sym.Symbol))
{
var info = infos[sym.Symbol];
if(info!=null)
{
item.CompanyName = info.CompanyName;
item.EPS = Math.Round(info.EPS, 2);
item.PE = (info.EPS == 0) ? 0 : Math.Round(item.Price / info.EPS, 2);
}
}
items.Add(item);
}
currentData.RecordCount = items.Count;
currentData.PageIndex = 1;
currentData.PageCount = 1;
currentData.CompanyInfos = items.ToArray();
return currentData;
}
/// <summary>
/// Changing company's financial year
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnSelect_Click(object sender, EventArgs e)
{
try
{
if (MessageBox.Show("Are you sure you want to change the financial year?", "OpenMiracle", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)
{
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
FinancialYearBll bllFinancialYear = new FinancialYearBll();
decimal decFinacialId = Convert.ToDecimal(dgvChangeFinancialYear.CurrentRow.Cells["dgvtxtfinancialYearId"].Value);
DateTime dtmFromDate = Convert.ToDateTime(dgvChangeFinancialYear.CurrentRow.Cells["dgvtxtFromDate"].Value);
DateTime dtmToDate = Convert.ToDateTime(dgvChangeFinancialYear.CurrentRow.Cells["dgvtxtToDate"].Value);
PublicVariables._decCurrentFinancialYearId = decFinacialId;
PublicVariables._dtFromDate = dtmFromDate;
PublicVariables._dtToDate = dtmToDate;
DateTime dtGetCurrentdate = DateTime.Now;
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
bllCompanyCreation.CompanyCurrentDateEdit(dtmFromDate);
if (dtGetCurrentdate < dtmFromDate)
{
PublicVariables._dtCurrentDate = dtmFromDate;
bllCompanyCreation.CompanyCurrentDateEdit(dtmFromDate);
formMDI.MDIObj.ShowCurrentDate();
}
else
{
PublicVariables._dtCurrentDate = dtGetCurrentdate;
bllCompanyCreation.CompanyCurrentDateEdit(dtmFromDate);
formMDI.MDIObj.ShowCurrentDate();
}
CompanyInfo infoCompany = new CompanyInfo();
infoCompany = bllCompanyCreation.CompanyView(1);
formMDI.MDIObj.Text = "OpenMiracle " + infoCompany.CompanyName + " [ " + PublicVariables._dtFromDate.ToString("dd-MMM-yyyy") + " To " + PublicVariables._dtToDate.ToString("dd-MMM-yyyy") + " ]";
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show("CHGFINYR:5" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public int InsertByOutput(CompanyInfo model)
{
return(dal.InsertByOutput(model));
}
/// <summary>
/// 获取企业信息列表
/// </summary>
/// <returns></returns>
public string GetCompanyList()
{
if (Signature != GetParam("sig").ToString())
{
ErrorCode = (int)ErrorType.API_EC_SIGNATURE;
return "";
}
//如果是桌面程序则需要验证用户身份
if (this.App.ApplicationType == (int)ApplicationType.DESKTOP)
{
if (Uid < 1)
{
ErrorCode = (int)ErrorType.API_EC_SESSIONKEY;
return "";
}
}
if (CallId <= LastCallId)
{
ErrorCode = (int)ErrorType.API_EC_CALLID;
return "";
}
if (!CheckRequiredParams("cnums,ordercol"))
{
ErrorCode = (int)ErrorType.API_EC_PARAM;
return "";
}
int cnums = GetIntParam("cnums", 10);
string orderby = GetParam("ordercol") == null ? "" : GetParam("ordercol").ToString();
List<SAS.Entity.Companys> clist = new List<SAS.Entity.Companys>();
switch (orderby)
{
case "credit":
clist = SAS.Data.DataProvider.Companies.GetCompanyListByOrder(cnums, "en_credits", true);
break;
default:
clist = SAS.Data.DataProvider.Companies.GetCompanyListByOrder(cnums, "en_createdate", true);
break;
}
CompanyGetListResponse gglr = new CompanyGetListResponse();
List<CompanyInfo> cilist = new List<CompanyInfo>();
foreach (SAS.Entity.Companys cmodel in clist)
{
CompanyInfo cinfo = new CompanyInfo();
cinfo.Enid = cmodel.En_id;
cinfo.Ename = cmodel.En_name;
cinfo.Enaccesses = cmodel.En_accesses;
cinfo.Encredits = cmodel.En_credits;
if (cmodel.En_cataloglist.Split(',').Length > 0)
{
cinfo.Encatalogid = Utils.StrToInt(cmodel.En_cataloglist.Split(',')[0], 0);
}
SAS.Entity.CatalogInfo catainfo = Catalogs.GetCatalogCacheInfo(cinfo.Encatalogid);
cinfo.Encatalogname = catainfo == null ? string.Empty:catainfo.name;
cilist.Add(cinfo);
}
gglr.Cnums = cilist.Count;
gglr.CompanyList = cilist.ToArray();
if (Format == FormatType.JSON)
{
return JavaScriptConvert.SerializeObject(gglr);
}
return SerializationHelper.Serialize(gglr);
}
/// <summary>
/// Start a login
/// </summary>
public void Login()
{
try
{
UserBll bllUser = new UserBll();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
CompanyInfo infoCompany = new CompanyInfo();
string strUserName = txtUserName.Text.Trim();
string strPassword = bllUser.LoginCheck(strUserName);
if (strPassword == txtPassword.Text.Trim() && strPassword != string.Empty)
{
int inUserId = bllUser.GetUserIdAfterLogin(strUserName, strPassword);
PublicVariables._decCurrentUserId = inUserId;
infoCompany = bllCompanyCreation.CompanyView(1);
PublicVariables._decCurrencyId = infoCompany.CurrencyId;
formMDI.MDIObj.CallFromLogin();
SettingsCheck();
//for Quock Launch menu
formMDI.MDIObj.ShowQuickLaunchMenu();
formMDI.MDIObj.CurrentSettings();
//Display ChangeCurrentDate form//
frmChangeCurrentDate frmCurrentDateChangeObj = new frmChangeCurrentDate();
frmCurrentDateChangeObj.MdiParent = formMDI.MDIObj;
frmCurrentDateChangeObj.CallFromLogin(this);
formMDI.MDIObj.Text = "OpenMiracle " + infoCompany.CompanyName + " [ " + PublicVariables._dtFromDate.ToString("dd-MMM-yyyy") + " To " + PublicVariables._dtToDate.ToString("dd-MMM-yyyy") + " ]";
// For showing the OpenMiracle message from the website
formMDI.MDIObj.logoutToolStripMenuItem.Enabled = true;
if (PublicVariables.MessageToShow != string.Empty)
{
frmMessage frmMsg = new frmMessage();
frmMsg.lblHeading.Text = PublicVariables.MessageHeadear;
frmMsg.lblMessage.Text = PublicVariables.MessageToShow;
frmMsg.MdiParent = formMDI.MDIObj;
frmMsg.Show();
frmMsg.Location = new Point(0, formMDI.MDIObj.Height - 270);
foreach (Form form in Application.OpenForms)
{
if (form.GetType() == typeof(frmChangeCurrentDate))
{
form.Focus();
}
}
}
}
else
{
Messages.InformationMessage("Invalid username or password");
Clear();
}
}
catch (Exception ex)
{
MessageBox.Show("LOGIN02:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// To set current date
/// </summary>
public void CurrentDate()
{
try
{
dtpCompanyCurrentDate.MinDate = PublicVariables._dtFromDate;
dtpCompanyCurrentDate.MaxDate = PublicVariables._dtToDate;
CompanyInfo infoComapany = new CompanyInfo();
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
infoComapany = bllCompanyCreation.CompanyView(1);
DateTime dtCurrentDate = PublicVariables._dtFromDate;
if (infoComapany.CurrentDate != null)
{
dtCurrentDate = infoComapany.CurrentDate;
}
if (dtCurrentDate > PublicVariables._dtToDate)
{
dtCurrentDate = PublicVariables._dtToDate;
}
if (dtCurrentDate < PublicVariables._dtFromDate)
{
dtCurrentDate = PublicVariables._dtFromDate;
}
dtpCompanyCurrentDate.Value = dtCurrentDate;
PublicVariables._dtCurrentDate = dtCurrentDate;
DateTime sysDate = System.DateTime.Today;
if (sysDate >= PublicVariables._dtFromDate && sysDate <= PublicVariables._dtToDate)
{
txtCompanyCurrentdate.Text = sysDate.ToString("dd-MMM-yyyy");
}
else
{
txtCompanyCurrentdate.Text = dtCurrentDate.ToString("dd-MMM-yyyy");
}
dtpCompanyCurrentDate.Value = Convert.ToDateTime(txtCompanyCurrentdate.Text);
txtCompanyCurrentdate.Focus();
txtCompanyCurrentdate.SelectAll();
}
catch (Exception ex)
{
MessageBox.Show("CCD 3 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
void GenerateCompanyList(string strCommText)
{
lblNoResultsFound.Visible = false;
dtCompanyInfo = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable(strCommText);
List<CompanyInfo> ListCompanyRow = new List<CompanyInfo>();
if (dtCompanyInfo.Rows.Count > 0)
{
int n = dtCompanyInfo.Rows.Count;
string[] strIndustryS = new string[n];
for (int j = 0; j < dtCompanyInfo.Rows.Count; j++)
{
string strCompanyid = dtCompanyInfo.Rows[j]["CompanyID"].ToString();
DataTable dtIndustry = CareerCruisingWeb.CCLib.Common.DataAccess.GetDataTable("select IndustryDescr" + CareerCruisingWeb.CCLib.Common.Strings.SuffixCode() + " from Con_CompanyIndustries AS ci INNER JOIN Con_IndustriesLookup AS il ON ci.CompanyID=" + strCompanyid + " and ci.IndustryID = il.IndustryID");
strIndustryS.SetValue("", j);
for (int i = 0; i < dtIndustry.Rows.Count; i++)
{
if ((i > 0) && (i < dtIndustry.Rows.Count))
{
strIndustryS[j] = strIndustryS[j] + ", " + dtIndustry.Rows[i]["IndustryDescr" + CareerCruisingWeb.CCLib.Common.Strings.SuffixCode()].ToString();
}
else
{ strIndustryS[j] = strIndustryS[j] + dtIndustry.Rows[i]["IndustryDescr" + CareerCruisingWeb.CCLib.Common.Strings.SuffixCode()].ToString(); }
}
CompanyInfo s = new CompanyInfo();
s.CompanyID = strCompanyid;
s.CompanyName = dtCompanyInfo.Rows[j]["CompanyName"].ToString();
s.IndustryName = strIndustryS[j];
ListCompanyRow.Add(s);
}
rptCompanyInfo.DataSource = ListCompanyRow;
rptCompanyInfo.DataBind();
rptCompanyInfo.Visible = true;
if (dtCompanyInfo.Rows.Count < 7)
{
pgParent = (CareerCruisingWeb.PageBase.SuperBase)this.Page;
pgParent.IsLongPage = false;
}
}
else
{
lblNoResultsFound.Text = ((CareerCruisingWeb.PageBase.SuperBase)Page).TextCode(5692);
lblNoResultsFound.Visible = true;
if (PageT.ToUpper() == "KW")
{
// insert keyword into freetext keyword search log
string strSQL = "INSERT INTO KeywordSearchLog (Keyword,Section,Country) VALUES ('" + KeywordS + "','Company search','" + strCountry + "')";
int rowsUpdated = CareerCruisingWeb.CCLib.Common.DataAccess.ExecuteNonQuery(strSQL);
}
rptCompanyInfo.Visible = false;
pgParent = (CareerCruisingWeb.PageBase.SuperBase)this.Page;
pgParent.IsLongPage = false;
}
}
/// <summary>
/// Function to Get the Current Date
/// </summary>
public void CurrentDate()
{
try
{
CompanyInfo infoComapany = new CompanyInfo();
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
FinancialYearBll bllFinancialYear = new FinancialYearBll();
infoComapany = bllCompanyCreation.CompanyView(1);
PublicVariables._dtCurrentDate = infoComapany.CurrentDate;
infoFinancialYear = bllFinancialYear.FinancialYearView(1);
PublicVariables._dtFromDate = infoFinancialYear.FromDate;
PublicVariables._dtToDate = infoFinancialYear.ToDate;
}
catch (Exception ex)
{
MessageBox.Show("SELCMPNY :2 " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
public bool isValid(CompanyInfo obj)
{
bool isValid = !obj.Errors.Any();
return(isValid);
}
public static CompanyInfo SearchCompany(int tradeId, int industryId, FilterType filterType, string keyword, int pageIndex, int pageSize)
{
CompanyInfo currentData = new CompanyInfo();
//if (!string.IsNullOrEmpty(keyword))
//{
// keyword = keyword.Replace("'", "");
//}
//else
//{
// keyword = "";
//}
//CompanyHelper_Update company = new CompanyHelper_Update();
//currentData.RecordCount = company.Select_Count_TradeCenter(keyword, industryId, tradeId, (int)filterType);
//currentData.PageIndex = pageIndex;
//if (currentData.RecordCount > 1)
//{
// currentData.PageCount = ((int)(currentData.RecordCount - 1) / pageSize) + 1;
//}
//else
//{
// currentData.PageCount = 1;
//}
//if (pageIndex <= 0)
//{
// currentData.PageIndex = 1;
//}
//else
//{
// if (pageIndex > currentData.PageCount)
// {
// currentData.PageIndex = currentData.PageCount;
// }
// else
// {
// currentData.PageIndex = pageIndex;
// }
//}
//using (DataTable dtCompanies = company.GetTradeCenter(tradeId, keyword, industryId, currentData.PageIndex, pageSize, (int)filterType))
//{
// List<CompanyInfoItem> items = new List<CompanyInfoItem>();
// if (dtCompanies != null)
// {
// using (DataTable dtCompaniesIncludePrice = GetOnlineInfo(dtCompanies))
// {
// for (int i = 0; i < dtCompaniesIncludePrice.Rows.Count; i++)
// {
// items.Add(new CompanyInfoItem(dtCompaniesIncludePrice.Rows[i]["StockSymbol"].ToString(),
// dtCompaniesIncludePrice.Rows[i]["Fullname"].ToString(),
// dtCompaniesIncludePrice.Rows[i]["Symbol"].ToString(),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["CurrentPrice"]),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["PE"]),
// Lib.Object2Double(dtCompaniesIncludePrice.Rows[i]["EPS"])
// ));
// }
// }
// }
// currentData.CompanyInfos = items.ToArray();
//}
//return currentData;
var items = new List<CompanyInfoItem>();
var key = tradeId > 0 ? string.Format(RedisKey.KeyStockListByCenter, tradeId) : RedisKey.KeyStockList;
var sds = BLFACTORY.RedisClient.Get<List<StockCompact>>(key);
sds = sds.FindAll(s => s.Symbol.Contains(keyword) && (industryId == -1||s.CategoryId==industryId));
if(filterType==FilterType.StockSymbol)
{
currentData.RecordCount = sds.Count;
//Neu loc theo chu cai
sds = sds.GetPaging(pageIndex, pageSize);
}
var ss = new List<string>();
Dictionary<string, StockCompactInfo> infos;
if (filterType == FilterType.NoFilter && !string.IsNullOrEmpty(keyword))
{
foreach (var sym in sds)
{
ss.Add(sym.Symbol);
}
infos = StockBL.GetStockCompactInfoMultiple(ss);
foreach (var info in infos)
{
if (info.Value == null) continue;
var sym = info.Value.Symbol;
//ss.Remove(info.Value.Symbol);
var index = sds.FindIndex(s=>s.Symbol==sym);
if(index >0) sds.RemoveAt(index);
}
currentData.RecordCount = sds.Count;
sds = sds.GetPaging(pageIndex, pageSize);
}
if (sds.Count > pageSize)
{
currentData.RecordCount = sds.Count;
sds = sds.GetPaging(pageIndex, pageSize);
}
ss = new List<string>();
foreach (var sym in sds)
{
ss.Add(sym.Symbol);
}
infos = StockBL.GetStockCompactInfoMultiple(ss);
var prices = StockBL.GetStockPriceMultiple(ss);
foreach (var sym in sds)
{
var item = new CompanyInfoItem {Symbol = sym.Symbol, TradeCenter = Utils.GetCenterName(sym.TradeCenterId.ToString()), Price = 0, CompanyName = ""};
if (prices.ContainsKey(sym.Symbol))
{
var price = prices[sym.Symbol];
if (price != null)
{
item.Price = price.Price;
}
}
if (infos.ContainsKey(sym.Symbol))
{
var info = infos[sym.Symbol];
if (info != null)
{
item.CompanyName = info.CompanyName;
item.EPS = Math.Round(info.EPS,2);
item.PE = (info.EPS == 0) ? 0 : Math.Round(item.Price / info.EPS, 2);
}
}
if(string.IsNullOrEmpty(item.CompanyName)) continue;
items.Add(item);
}
currentData.PageIndex = pageIndex;
currentData.PageCount = (int)Math.Ceiling((double)currentData.RecordCount / pageSize);
currentData.CompanyInfos = items.ToArray();
return currentData;
}
protected string GetNickName()
{
CompanyInfo comp = StaticCacheManager.GetConfig <CompanyInfo>();
return(comp.NickName);
}
protected void Page_Load(object sender, System.EventArgs e)
{
base.NeedLogin = true;
base.ReturnUrl = Request.RawUrl;
if (base.IsPost && base.UserID != -1)
{
string text = WebUtils.GetFormString("_action", "add").ToLower();
int formInt = WebUtils.GetFormInt("_idcom");
CompanyInfo com = new CompanyInfo();
if (text.Equals("modify"))
{
com = Company.GetDataById(formInt);
}
com.Name = WebUtils.GetFormString("name");
com.Address = WebUtils.GetFormString("address");
com.Phone = WebUtils.GetFormString("phone");
if (text == "del")
{
if (Company.Delete(formInt))
{
base.WriteJsonTip(true, base.GetCaption("Comp_Success"));
}
else
{
base.WriteJsonTip(base.GetCaption("Comp_DeleteFail"));
}
}
else if (string.IsNullOrEmpty(com.Name))
{
base.WriteJsonTip(base.GetCaption("Comp_NameNotEmpty"));
}
else if (string.IsNullOrEmpty(com.Address))
{
base.WriteJsonTip(base.GetCaption("Comp_AddressNotEmpty"));
}
else if (string.IsNullOrEmpty(com.Phone))
{
base.WriteJsonTip(base.GetCaption("Comp_PhoneNotEmpty"));
}
else if (text == "modify")
{
if (Company.Update(com))
{
base.WriteJsonTip(true, base.GetCaption("Comp_Success"));
}
else
{
base.WriteJsonTip(base.GetCaption("Comp_UpdateFail"));
}
}
else
{
com.AutoTimeStamp = System.DateTime.Now;
int num = Company.Add(com);
if (num > 0)
{
base.WriteJsonTip(true, base.GetCaption("Comp_Success"));
}
else
{
base.WriteJsonTip(base.GetCaption("Comp_AddFail"));
}
}
}
else
{
int pageSize = 15;
StringBuilder builderCondition = new StringBuilder(" 1=1 ");
string strSort = " AutoID desc ";
StringBuilder builderUrlPattern = new StringBuilder(base.ResolveUrl("~/List_Company.aspx"));
builderUrlPattern.Append("?");
builderUrlPattern.Append("&page=$page");
CMSPager pager = contents.GetPager(BLL.Company.GetCount(builderCondition.ToString()), intCurrentPage, pageSize, builderUrlPattern.ToString());
base.Put("pager", pager);
IList <CompanyInfo> company = BLL.Company.GetPagerList(builderCondition.ToString(), strSort, pager.PageIndex, pager.PageSize, ref intTotalCount, ref intTotalPage);
base.Put("com", company);
base.UsingClient("temp/content_company.html");
}
}
private void Estadisticas_BT_Click(object sender, EventArgs e)
{
if (EntityInfo.FechaEmision.Date > DateTime.Today.Date)
{
MessageBox.Show(Resources.Messages.EXAMEN_NO_EMITIDO);
return;
}
if (!EntityInfo.Desarrollo)
{
EstadisticaExamenList estadisticas = EstadisticaExamenList.GetList(Entity);
ShowChartAction(estadisticas);
ExamenReportMng reportMng = new ExamenReportMng(AppContext.ActiveSchema);
EstadisticaExamenRpt rpt = reportMng.GetEstadisticaReport(EntityInfo, estadisticas, CompanyInfo.Get(AppContext.ActiveSchema.Oid, false));
ReportViewer.SetReport(rpt);
ReportViewer.ShowDialog();
}
}
protected void HtmlOut()
{
startDate = Convert.ToDateTime(RequestHelper.GetQueryString <string>("SearchStartDate"));
endDate = Convert.ToDateTime(RequestHelper.GetQueryString <string>("SearchEndDate")).AddDays(1);
SearchStartDate.Text = startDate.ToString("d");
SearchEndDate.Text = endDate.AddDays(-1).ToShortDateString();
int WeekNum = 0, ColNum = 14;
int PeoperNum = 0;
StringBuilder TextOut = new StringBuilder();
CompanyInfo company = CompanyBLL.ReadCompany(companyID);
companyName = company.CompanyName;
//string CompanyBrandId = company.BrandId;
bool isGroupCompany = base.IsGroupCompany(company.GroupId);
if (isGroupCompany)
{
ColNum = 15;
}
string rowspan = string.Empty;
TextOut.Append("<table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\">");
TextOut.Append("<thead>");
TextOut.Append("<tr class=\"listTableHead\">");
//循环开始日期
DateTime loopStartDate = startDate;
if (SelectMonth == "Other")
{
//目前只要一周的数据
loopStartDate = endDate.AddDays(-7);
WeekNum = (endDate - loopStartDate).Days / 7;
if ((endDate - loopStartDate).Days % 7 > 0)
{
WeekNum = WeekNum + 1;
}
TextOut.Append("<th colspan=\"" + (ColNum + WeekNum) + "\">" + company.CompanySimpleName);//+ " [" + loopStartDate.ToString("d") + "—" + EndDate.AddDays(-1).ToString("d") + "]"
rowspan = " rowspan=\"2\"";
}
TextOut.Append("</th></tr>\r\n");
TextOut.Append("<tr class=\"listTableHead\">\r\n");
TextOut.Append("<th" + rowspan + ">序号</th>");
if (isGroupCompany)
{
TextOut.Append("<td" + rowspan + ">公司名</th>");
}
TextOut.Append("<th" + rowspan + " data-sort=\"string\">姓名</th>");
TextOut.Append("<th" + rowspan + " data-sort=\"string\">工作岗位</th>");
TextOut.Append("<th" + rowspan + " data-sort=\"string\">学习岗位</th>");
TextOut.Append("<th" + rowspan + " data-sort=\"string\">状态</th>");
TextOut.Append("<th" + rowspan + ">初考时间</th>");
TextOut.Append("<th" + rowspan + ">岗位课程数</th>");
TextOut.Append("<th" + rowspan + " data-sort=\"int\">岗位课程<br>完成总数</th>");
TextOut.Append("<th" + rowspan + " data-sort=\"int\">岗位剩余<br>课程总数</th>");
TextOut.Append("<th" + rowspan + " data-sort=\"int\">学习完成率</th>");
TextOut.Append("<th" + rowspan + ">所有已过岗位</th>");
TextOut.Append("<th" + rowspan + " data-sort=\"int\">已过岗位数量<i class=\"icon_arrow\"></i></th>");
TextOut.Append("<th" + rowspan + ">岗位已学习<br>考试未通过</th>");
TextOut.Append("<th" + rowspan + ">已通过数量</th>");
if (SelectMonth == "Other")
{
TextOut.Append("<th colspan=\"" + WeekNum.ToString() + "\">学习已通过</th></tr>\r\n");
TextOut.Append("<tr class=\"listTableHead\">\r\n");
for (int j = 1; j <= WeekNum; j++)
{
TextOut.Append("<th>第" + j.ToString() + "周<br>" + loopStartDate.AddDays(7 * (j - 1)).ToString("M-d") + "—");
if (j == WeekNum)
{
TextOut.Append(endDate.AddDays(-1).ToString("M-d") + "</th>");
}
else
{
TextOut.Append(loopStartDate.AddDays((7 * j) - 1).ToString("M-d") + "</th>");
}
}
TextOut.Append("</tr>\r\n");
}
TextOut.Append("</thead>");
TextOut.Append("<tbody>");
UserSearchInfo user = new UserSearchInfo();
user.InStatus = state;
user.InGroupID = groupID;
user.InWorkingPostID = postIdCondition;
user.InStudyPostID = studyPostIdCondition; //只显示该学习岗位下的人员
if (isGroupCompany)
{
user.InCompanyID = CompanyBLL.ReadCompanyIdList(companyID.ToString());
//user.StudyPostIdCondition = "45";//集团打开默认显示学习岗位
}
else
{
user.InCompanyID = companyID.ToString();
}
if (rzDate == 1)
{
if (rz == 0)
{
user.Condition = "[id] not in (select [userid] from [_passpost] where [CreateDate]<='" + endDate + "' and [isrz]=1 and [_passpost].[postid] in (select [postid] from [_post]))";
}
else if (rz == 1)
{
user.Condition = "[id] in (select [userid] from [_passpost] where [CreateDate]<='" + endDate + "' and [isrz]=1 and [_passpost].[postid] in (select [postid] from [_post]))";
}
}
else if (rzDate == 0)
{
if (rz == 0)
{
user.Condition = "[id] not in (select [userid] from [_passpost] where [CreateDate]>='" + startDate + "' And [CreateDate]<='" + endDate + "' and [isrz]=1 and [_passpost].[postid] in (select [postid] from [_post]))";
}
else if (rz == 1)
{
user.Condition = "[id] in (select [userid] from [_passpost] where [CreateDate]>='" + startDate + "' And [CreateDate]<='" + endDate + "' and [isrz]=1 and [_passpost].[postid] in (select [postid] from [_post]))";
}
}
//user.Condition = string.IsNullOrEmpty(user.Condition) ? "Order by [CompanyID] Desc" : user.Condition + " Order by [CompanyID] Desc";
//user.PostIdCondition = PostIdStr;
List <UserInfo> userList = UserBLL.SearchReportUserList(user);//UserBLL.SearchUserList(user);
//把公司所有员工的第一次考试记录都一起调起
List <TestPaperReportInfo> userFirstTestRecordList = TestPaperBLL.ReadTheFirstRecordList(user.InCompanyID);
//把公司所有员工的考试记录都一起调起
TestPaperInfo TestPaperModel = new TestPaperInfo();
//if (!string.IsNullOrEmpty(company.PostStartDate.ToString()))
// TestPaperModel.TestMinDate = Convert.ToDateTime(company.PostStartDate);
TestPaperModel.TestMaxDate = endDate;
TestPaperModel.CompanyIdCondition = user.InCompanyID;
//TestPaperModel.Field = "UserID";
TestPaperModel.Condition = "[UserID] in (select [ID] from [_User] where [CompanyID] in (" + user.InCompanyID + ")";
if (!string.IsNullOrEmpty(groupID))
{
TestPaperModel.Condition += " and [GroupID] in (" + groupID + ")";
}
if (!string.IsNullOrEmpty(postIdCondition))
{
TestPaperModel.Condition += " and [WorkingPostID] in (" + postIdCondition + ")";
}
if (!string.IsNullOrEmpty(studyPostIdCondition))
{
TestPaperModel.Condition += " and [StudyPostId] in (" + studyPostIdCondition + ")";
}
if (!string.IsNullOrEmpty(state))
{
TestPaperModel.Condition += " and [Status] in (" + state + ")";
}
TestPaperModel.Condition += ")";
List <TestPaperInfo> TestPaperList = TestPaperBLL.NewReadList(TestPaperModel);
foreach (UserInfo Info in userList)
{
int PostId = int.MinValue;
PostId = Info.StudyPostID;
PostInfo PostModel = PostBLL.ReadPost(Info.StudyPostID);
if (PostModel != null) //排除掉没有设置岗位的人
{
//string PassCateId = TestPaperBLL.ReadListStr(Info.ID, endDate, 1);
//string NoPassCateId = TestPaperBLL.ReadListStr(Info.ID, endDate, 0);
//筛选出当前用户ID的成绩列表
List <TestPaperInfo> currentUserPaperList = TestPaperList.FindAll(delegate(TestPaperInfo TempModel) { return(TempModel.UserId == Info.ID); });
List <TestPaperInfo> currentUserPassPaperList = currentUserPaperList.FindAll(delegate(TestPaperInfo TempModel) { return(TempModel.IsPass == 1); });
List <TestPaperInfo> currentUserNoPassPaperList = currentUserPaperList.FindAll(delegate(TestPaperInfo TempModel) { return(TempModel.IsPass == 0); });
string PassCateId = TestPaperBLL.ReadCourseIDStr(currentUserPassPaperList);
string NoPassCateId = TestPaperBLL.ReadCourseIDStr(currentUserNoPassPaperList);
//从未通过的记录中去除后期又补考通过的记录
NoPassCateId = StringHelper.SubString(NoPassCateId, PassCateId);
int PostCourseNum = 0;
int PassCourseNum = 0;
int NoPassCourseNum = 0;
//岗位下所有已过级别的岗位课程
//if (isGroupCompany)
// CompanyBrandId = CompanyBLL.ReadCompany(Info.CompanyID).BrandId;
string AllPostPlan = PostBLL.ReadPostCourseID(Info.CompanyID, Info.StudyPostID);//PostBLL.ReadPostCourseID(Info.StudyPostID, CompanyBrandId);
if (string.IsNullOrEmpty(AllPostPlan))
{
PostCourseNum = 0;
}
else
{
PostCourseNum = AllPostPlan.Split(',').Length;
}
string PassPostCateId = StringHelper.EqualString(PassCateId, AllPostPlan);
string NoPassPostCateId = StringHelper.EqualString(AllPostPlan, NoPassCateId);
if (string.IsNullOrEmpty(PassPostCateId))
{
PassCourseNum = 0;
}
else
{
PassCourseNum = PassPostCateId.Split(',').Length;
}
//选取时间段内
if (rzDate == 0)
{
//时间段内的学习中的岗位课程补丁，去掉即为到截止时间所有的学习中的岗位课程
if (SelectMonth == "Other")
{
NoPassPostCateId = StringHelper.EqualString(NoPassPostCateId, TestPaperBLL.ReadCourseIDStr(currentUserNoPassPaperList.FindAll(delegate(TestPaperInfo TempModel) { return(TempModel.TestDate >= startDate && TempModel.TestDate <= endDate); })));
}
//补丁结束
}
if (string.IsNullOrEmpty(NoPassPostCateId))
{
NoPassCourseNum = 0;
}
else
{
NoPassCourseNum = NoPassPostCateId.Split(',').Length;
}
//如果公司ID不同，再次获取公司信息，减少重复操作
if (Info.CompanyID != company.CompanyId)
{
company = CompanyBLL.ReadCompany(Info.CompanyID);
}
string PastPassCourse = string.Empty;
PeoperNum = PeoperNum + 1;
TextOut.Append("<tr class=\"listTableMain\">\r\n");
TextOut.Append("<td>" + PeoperNum + "</td>");
if (isGroupCompany)
{
TextOut.Append("<td>" + company.CompanySimpleName + "</td>");
}
TextOut.Append("<td>" + Info.RealName + "</td>");
if (!string.IsNullOrEmpty(Info.PostName))
{
TextOut.Append("<td>" + Info.PostName + "</td>");
}
else
{
TextOut.Append("<td>" + PostBLL.ReadPost(Info.WorkingPostID).PostName + "</td>");
}
TextOut.Append("<td>" + PostModel.PostName + "</td>");
TextOut.Append("<td>" + EnumHelper.ReadEnumChineseName <UserState>(Info.Status) + "</td>");
//DateTime firstTestDate = TestPaperBLL.ReadTheOldTestPaperInfo(Info.ID).TestDate;
TestPaperReportInfo currentUserFirstTestRecord = userFirstTestRecordList.Find(delegate(TestPaperReportInfo tempModel) { return(tempModel.UserID == Info.ID); });
if (currentUserFirstTestRecord != null)
{
TextOut.Append("<td>" + currentUserFirstTestRecord.TestDate.ToString("d") + "</td>");
}
else
{
TextOut.Append("<td> </td>");
}
TextOut.Append("<td>" + PostCourseNum.ToString() + "</td>");
TextOut.Append("<td>" + PassCourseNum.ToString() + "</td>");
TextOut.Append("<td>" + (PostCourseNum - PassCourseNum) + "</td>");
if (PostCourseNum > 0)
{
TextOut.Append("<td>" + (Math.Round((double)PassCourseNum / PostCourseNum, 4) * 100) + "%</td>");
}
else
{
TextOut.Append("<td>0</td>");
}
int passPostNum = 0;
if (rzDate == 1)
{
TextOut.Append("<td>" + PostPassBLL.ReadPassPostName(Info.ID, endDate, ref passPostNum) + "</td>");
}
else
{
TextOut.Append("<td>" + PostPassBLL.ReadPassPostName(Info.ID, startDate, endDate, ref passPostNum) + "</td>");
}
TextOut.Append("<td>" + passPostNum + "</td>");
TextOut.Append("<td>" + (NoPassCourseNum) + "</td>");
if (rzDate == 0)
{
List <TestPaperInfo> tempList = currentUserPassPaperList.FindAll(m => m.TestDate >= startDate && m.TestDate <= endDate);
if (tempList.Count > 0)
{
TextOut.Append("<td>" + TestPaperBLL.ReadCourseIDStr(tempList).Split(',').Length + "</td>");
}
else
{
TextOut.Append("<td>0</td>");
}
}
else
{
TextOut.Append("<td>" + (string.IsNullOrEmpty(PassCateId) ? 0 : PassCateId.Split(',').Length) + "</td>");
}
if (SelectMonth == "Other")
{
for (int j = 1; j <= WeekNum; j++)
{
if (j == WeekNum)
{
PastPassCourse = StringHelper.EqualString(AllPostPlan, TestPaperBLL.ReadCourseIDStr(currentUserPassPaperList.FindAll(delegate(TestPaperInfo TempModel) { return(TempModel.TestDate >= loopStartDate.AddDays(7 * (j - 1)) && TempModel.TestDate <= endDate); }))); //TestPaperBLL.ReadListStr(Info.ID, loopStartDate.AddDays(7 * (j - 1)), endDate, 1)
}
else
{
PastPassCourse = StringHelper.EqualString(AllPostPlan, TestPaperBLL.ReadCourseIDStr(currentUserPassPaperList.FindAll(delegate(TestPaperInfo TempModel) { return(TempModel.TestDate >= loopStartDate.AddDays(7 * (j - 1)) && TempModel.TestDate <= loopStartDate.AddDays(7 * j)); }))); //TestPaperBLL.ReadListStr(Info.ID, loopStartDate.AddDays(7 * (j - 1)), loopStartDate.AddDays(7 * j), 1)
}
int PastPassCourseNum = 0;
if (!string.IsNullOrEmpty(PastPassCourse))
{
PastPassCourseNum = PastPassCourse.Split(',').Length;
}
TextOut.Append("<td>" + (PastPassCourseNum) + "</td>");
}
}
else
{
//计算到上个时间学过的课程数
//算法(到现在所有通过的课程-到上个时间点所有完成的课程=时间段内新增课程)
//时间段内新增课程与岗位计划相同的部分=时间段内新增课程
PastPassCourse = StringHelper.EqualString(AllPostPlan, StringHelper.SubString(PassCateId, TestPaperBLL.ReadCourseIDStr(currentUserPassPaperList.FindAll(delegate(TestPaperInfo TempModel) { return(TempModel.TestDate <= startDate); })))); //TestPaperBLL.ReadListStr(Info.ID, startDate, 1)
int PastPassCourseNum = 0;
if (!string.IsNullOrEmpty(PastPassCourse))
{
PastPassCourseNum = PastPassCourse.Split(',').Length;
}
TextOut.Append("<td>" + (PastPassCourseNum) + "</td>");
}
TextOut.Append("</tr>\r\n");
}
}
TextOut.Append("</tbody>");
TextOut.Append("</table>");
this.ReportList.InnerHtml = TextOut.ToString();
}
/// <summary>
/// Function for Save
/// </summary>
public void SaveFunction()
{
try
{
CompanyInfo infoCompany = new CompanyInfo();
CompanyCreationBll BllCompanyCreation = new CompanyCreationBll();
CompanyPathInfo infoCompanyPath = new CompanyPathInfo();
CompanyPathBll BllCompanyPath = new CompanyPathBll();
UserInfo infoUser = new UserInfo();
UserBll bllUser = new UserBll();
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
//ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
infoCompany.CompanyName = txtCompanyName.Text.Trim();
infoCompany.MailingName = txtMailingName.Text.Trim();
infoCompany.Address = txtAddress.Text.Trim();
infoCompany.Phone = txtPhoneNo.Text.Trim();
infoCompany.Mobile = txtMobile.Text.Trim();
infoCompany.EmailId = txtEmail.Text.Trim();
infoCompany.Web = txtWeb.Text.Trim();
infoCompany.Country = txtCountry.Text.Trim();
infoCompany.State = txtState.Text.Trim();
infoCompany.Pin = txtPincode.Text.Trim();
infoCompany.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
decCurrencyIdForStatus = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoCompany.FinancialYearFrom = Convert.ToDateTime(txtFinancialYearFrom.Text.Trim().ToString());
infoCompany.BooksBeginingFrom = Convert.ToDateTime(txtBooksBegining.Text.Trim().ToString());
infoCompany.Tin = txtTinNo.Text.Trim();
infoCompany.Cst = txtCstNo.Text.Trim();
infoCompany.Pan = txtPanNo.Text.Trim();
infoCompany.CurrentDate = DateTime.Now;
infoCompany.Logo = logo;
infoCompany.Extra1 = string.Empty;
infoCompany.Extra2 = string.Empty;
infoCompanyPath.CompanyName = txtCompanyName.Text.Trim();
infoCompanyPath.IsDefault = cbxSetAsDefault.Checked;
infoCompanyPath.Extra1 = string.Empty;
infoCompanyPath.Extra2 = string.Empty;
infoUser.UserName = txtAdminUserName.Text.Trim();
infoUser.Password = txtPassword.Text.Trim();
infoUser.Active = true;
infoUser.Extra1 = string.Empty;
infoUser.Extra2 = string.Empty;
infoUser.Narration = string.Empty;
infoUser.RoleId = 1;
if (BllCompanyCreation.CompanyCheckExistence(txtCompanyName.Text.Trim().ToString(), 0) == false)
{
decimal decCompanyId = BllCompanyCreation.CompanyAddParticularFeilds(infoCompany);
PublicVariables._decCurrentCompanyId = decCompanyId;
infoCompanyPath.CompanyPath = Application.StartupPath + "\\Data\\" + PublicVariables._decCurrentCompanyId;
BllCompanyPath.CompanyPathAdd(infoCompanyPath);
if (formMDI.demoProject || CreateCompany())
{
if (!formMDI.demoProject)
{
infoCompanyPath.CompanyPath = strPath;
}
else
{
infoCompanyPath.CompanyPath = Application.StartupPath + "\\Data";
PublicVariables._decCurrentCompanyId = 0;
}
CompanyInfo infoNewCompany = new CompanyInfo();
CompanyPathInfo infoNewCompanyPath = new CompanyPathInfo();
UserInfo infoNewUser = new UserInfo();
UserBll bllNewUser = new UserBll();
ExchangeRateInfo infoNewExchangeRate = new ExchangeRateInfo();
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
CompanyPathBll BllNewCompanyPath = new CompanyPathBll();
infoNewCompany = infoCompany;
infoNewCompanyPath = infoCompanyPath;
infoNewUser = infoUser;
decCompanyId = BllCompanyCreation.CompanyAddParticularFeilds(infoNewCompany);
bllNewUser.UserAdd(infoNewUser);
BllNewCompanyPath.CompanyPathAdd(infoNewCompanyPath);
Messages.SavedMessage();
formMDI.MDIObj.MenuStripEnabling();
// To set default currencyId.............//
infoNewExchangeRate.CurrencyId = infoNewCompany.CurrencyId;
infoNewExchangeRate.Rate = 1;
infoNewExchangeRate.Narration = string.Empty;
infoNewExchangeRate.Extra1 = string.Empty;
infoNewExchangeRate.Extra2 = string.Empty;
infoNewExchangeRate.ExtraDate = System.DateTime.Now;
infoNewExchangeRate.Date = System.DateTime.Now;
BllExchangeRate.ExchangeRateAdd(infoNewExchangeRate);
CurrencyBll BllCurrency = new CurrencyBll();
BllCurrency.DefaultCurrencySet(decCurrencyIdForStatus);
AfterCompanyCreation();
Clear();
this.Close();
}
else
{
Messages.InformationMessage("Company creation failed");
}
}
else
{
Messages.InformationMessage("Companyname already exist");
txtCompanyName.Focus();
}
}
catch (Exception ex)
{
MessageBox.Show("CR1:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
private async void TxtCVR_EditValueChanged(object sender, DevExpress.Xpf.Editors.EditValueChangedEventArgs e)
{
var s = sender as TextEditor;
if (s != null && s.IsLoaded)
{
var cvr = s.Text;
if (cvr == null || cvr.Length < 5)
{
return;
}
var allIsLetter = cvr?.All(x => char.IsLetter(x));
if (allIsLetter.HasValue && allIsLetter.Value == true)
{
return;
}
CompanyInfo ci = null;
try
{
#if !SILVERLIGHT
ci = await CVR.CheckCountry(cvr, editrow.Country);
#else
var lookupApi = new Uniconta.API.System.UtilityAPI(api);
ci = await lookupApi.LookupCVR(cvr, editrow.Country);
#endif
}
catch (Exception ex)
{
UnicontaMessageBox.Show(ex);
return;
}
if (!onlyRunOnce)
{
if (ci == null)
{
return;
}
if (!string.IsNullOrWhiteSpace(ci?.life?.name))
{
var address = ci.address;
if (address != null)
{
onlyRunOnce = true;
if (editrow._Address1 == null)
{
editrow.Address1 = address.CompleteStreet;
editrow.Address2 = address.ZipCity;
editrow.Country = address.Country;
}
else
{
var result = UnicontaMessageBox.Show(Uniconta.ClientTools.Localization.lookup("UpdateAddress"), Uniconta.ClientTools.Localization.lookup("Information"), UnicontaMessageBox.YesNo);
if (result != UnicontaMessageBox.Yes)
{
return;
}
{
editrow.Address1 = address.CompleteStreet;
editrow.Address2 = address.ZipCity;
editrow.Country = address.Country;
}
}
}
if (string.IsNullOrWhiteSpace(editrow._Name))
{
editrow._Name = ci.life.name;
}
if (!string.IsNullOrEmpty(ci.contact?.phone))
{
editrow.Phone = ci.contact.phone;
}
if (!string.IsNullOrEmpty(ci.contact?.www))
{
editrow.Www = ci.contact.www;
}
}
}
else
{
onlyRunOnce = false;
}
}
}
/// <summary>
/// To Display the company name in text box
/// </summary>
public void txtcompanynamefill()
{
try
{
//CompanySP spcompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
CompanyInfo infoCompany = new CompanyInfo();
infoCompany = bllCompanyCreation.CompanyView(1);
string strCompanyName = infoCompany.CompanyName;
txtShowCompanyName.Text = strCompanyName;
txtShowCompanyName.ReadOnly = true;
}
catch (Exception ex)
{
MessageBox.Show("BS3:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected virtual bool GetCompanyId(CompanyInfo company, out string id)
{
id = null;
return(false);
}
public override bool UpdateFromOnlineMusicTrackAlbumCompany(AlbumInfo albumInfo, CompanyInfo company, string language, bool cacheOnly)
{
if (!string.IsNullOrEmpty(company.MusicBrainzId))
{
return(true);
}
return(false);
}
protected virtual bool SetCompanyId(CompanyInfo company, string id)
{
return(false);
}
public override void StoreCompanyMatch(CompanyInfo company)
{
}
protected override bool TryGetFanArtInfo(BaseInfo info, out TLang language, out string fanArtMediaType, out bool includeThumbnails)
{
language = default(TLang);
fanArtMediaType = null;
includeThumbnails = true;
MovieInfo movieInfo = info as MovieInfo;
if (movieInfo != null)
{
language = FindBestMatchingLanguage(movieInfo.Languages);
fanArtMediaType = FanArtMediaTypes.Movie;
includeThumbnails = false;
return(true);
}
MovieCollectionInfo movieCollectionInfo = info as MovieCollectionInfo;
if (movieCollectionInfo != null)
{
language = FindBestMatchingLanguage(movieCollectionInfo.Languages);
fanArtMediaType = FanArtMediaTypes.MovieCollection;
return(true);
}
if (OnlyBasicFanArt)
{
return(false);
}
CompanyInfo companyInfo = info as CompanyInfo;
if (companyInfo != null)
{
language = FindMatchingLanguage(string.Empty);
fanArtMediaType = FanArtMediaTypes.Company;
return(true);
}
CharacterInfo characterInfo = info as CharacterInfo;
if (characterInfo != null)
{
language = FindMatchingLanguage(string.Empty);
fanArtMediaType = FanArtMediaTypes.Character;
return(true);
}
PersonInfo personInfo = info as PersonInfo;
if (personInfo != null)
{
if (personInfo.Occupation == PersonAspect.OCCUPATION_ACTOR)
{
fanArtMediaType = FanArtMediaTypes.Actor;
}
else if (personInfo.Occupation == PersonAspect.OCCUPATION_DIRECTOR)
{
fanArtMediaType = FanArtMediaTypes.Director;
}
else if (personInfo.Occupation == PersonAspect.OCCUPATION_WRITER)
{
fanArtMediaType = FanArtMediaTypes.Writer;
}
else
{
return(false);
}
language = FindMatchingLanguage(string.Empty);
return(true);
}
return(false);
}
public override void StoreMusicLabelMatch(CompanyInfo company)
{
}
//private void MoveAttachment(String TransactionGUID, String Attachmnent)
//{
// string ServerPath = Application.StartupPath + @"\TransientStorage";
// if (!Directory.Exists(ServerPath))
// {
// Directory.CreateDirectory(ServerPath);
// }
// if (Company_Info.CompanyCountryID != 0)
// {
// if (!Directory.Exists(ServerPath + "/" + Company_Info.CompanyCountryID))
// {
// Directory.CreateDirectory(ServerPath + "/" + Company_Info.CompanyCountryID);
// }
// }
// if (Company_Info.CompanyVAT != null)
// {
// if (!Directory.Exists(ServerPath + "/" + Company_Info.CompanyCountryID + "/" + Company_Info.CompanyVAT))
// {
// Directory.CreateDirectory(ServerPath + "/" + Company_Info.CompanyCountryID + "/" + Company_Info.CompanyVAT);
// }
// }
// String fileName = TransactionGUID + Path.GetExtension(Attachmnent);
// File.Move(Attachmnent, ServerPath + "/" + Company_Info.CompanyCountryID + "/" + Company_Info.CompanyVAT + "/" + fileName);
//}
public void ImportHakladaMokup(String filename, CompanyInfo _companyinfo, DBLayer _dblayer, char delimiter)
{
Company_Info = _companyinfo;
dblayer = _dblayer;
FiledHolder filedHolder = new FiledHolder();
filedHolder.InitINI();
filedHolder.Company_Info = Company_Info;
filedHolder.Add("CountryID");
filedHolder.Add("CompanyVAT");
filedHolder.Add("CompanyName");
filedHolder.Add("ActionCode");
filedHolder.Add("MisparMismach");
filedHolder.Add("TarichMismach");
filedHolder.Add("TarichAcher");
filedHolder.Add("ActionDetails");
filedHolder.Add("Maam");
filedHolder.Add("SchumPaturMaam");
filedHolder.Add("SchumMaam");
filedHolder.Add("SchumKolelMaam");
filedHolder.Add("Attachment");
filedHolder.LoadData();
StreamReader sr = new StreamReader(filename, CheckEncoder()); //Encoding.GetEncoding("iso-8859-8") //Hebrew From Magic
String line = "";
ArrayList flds = filedHolder.GetFileds();
//filedHolder.GetFiled("ActionCode")
dblayer.Current_Company_Info = _companyinfo;
//bool bSkipRow = false;
while (!sr.EndOfStream)
{
line = sr.ReadLine();
filedHolder.CurrentDataLine = line;
ShuratHaklada shurat_haklada = new ShuratHaklada();
String CompanyVAT = filedHolder.GetFiledValue(filedHolder.GetFiledPosition("CompanyVAT"), delimiter);
String CompanyName = filedHolder.GetFiledValue(filedHolder.GetFiledOrder("CompanyName"), delimiter);
Company company = CompanyIdentification.Identify(dblayer, Company_Info, null, CompanyVAT, CompanyName, null);
if (company != null)
{
shurat_haklada.CompanyID = company.CompanyID;
shurat_haklada.ActionCode = Convert.ToInt32(filedHolder.GetFiledValue("ActionCode"));
shurat_haklada.MisparMismach = Convert.ToInt32(filedHolder.GetFiledValue("MisparMismach"));
shurat_haklada.TarichMismach = Convert.ToDateTime(filedHolder.GetFiledValue("TarichMismach"));
shurat_haklada.TarichAcher = Convert.ToDateTime(filedHolder.GetFiledValue("TarichAcher"));
shurat_haklada.ActionDetails = filedHolder.GetFiledValue("ActionDetails");
shurat_haklada.AhuzHaMaam = Convert.ToDouble(filedHolder.GetFiledValue("Maam"));
shurat_haklada.SchumPaturMaam = Convert.ToDouble(filedHolder.GetFiledValue("SchumPaturMaam"));
shurat_haklada.SchumMaam = Convert.ToDouble(filedHolder.GetFiledValue("SchumMaam"));
shurat_haklada.SchumKolelMaam = Convert.ToDouble(filedHolder.GetFiledValue("SchumKolelMaam"));
shurat_haklada.Attachment = filedHolder.GetFiledValue("Attachment");
shurat_haklada.CompamyInfoCountryID = Company_Info.CompanyCountryID;
shurat_haklada.CompamyInfoVAT = Company_Info.CompanyVAT;
dblayer.AddHakladaRecord(shurat_haklada);
}
}
sr.Close();
}
public bool ValidDeleteObject(CompanyInfo companyInfo, IBranchOfficeService _branchOfficeService)
{
companyInfo.Errors.Clear();
//VDontHaveBranchOffices(companyInfo, _branchOfficeService);
return(isValid(companyInfo));
}
public override void EmailPDFAction()
{
if (ActiveItem == null)
{
return;
}
PgMng.Reset(10, 1, Face.Resources.Messages.RETRIEVING_DATA, this);
SerieInfo serie = SerieInfo.Get(ActiveItem.OidSerie, false);
PgMng.Grow();
ClienteInfo client = ClienteInfo.Get(ActiveItem.OidCliente, false);
PgMng.Grow();
TransporterInfo transporter = TransporterInfo.Get(ActiveItem.OidTransportista, ETipoAcreedor.TransportistaDestino, false);
PgMng.Grow();
CompanyInfo company = CompanyInfo.Get(AppContext.ActiveSchema.Oid);
PgMng.Grow();
FormatConfFacturaAlbaranReport conf = new FormatConfFacturaAlbaranReport();
conf.nota = (client.OidImpuesto == 1) ? Library.Invoice.Resources.Messages.NOTA_EXENTO_IGIC : string.Empty;
conf.nota += Environment.NewLine + (ActiveItem.Nota ? serie.Cabecera : "");
conf.cuenta_bancaria = ActiveItem.CuentaBancaria;
PgMng.Grow();
OutputInvoiceInfo item = OutputInvoiceInfo.Get(ActiveOID, true);
PgMng.Grow();
OutputInvoiceReportMng reportMng = new OutputInvoiceReportMng(AppContext.ActiveSchema, this.Text, this.FilterValues);
ReportClass report = reportMng.GetDetailReport(item, serie, client, transporter, conf);
PgMng.Grow();
if (report != null)
{
ExportOptions options = new ExportOptions();
DiskFileDestinationOptions diskFileDestinationOptions = new DiskFileDestinationOptions();
string fileName = Environment.GetFolderPath(Environment.SpecialFolder.Desktop);
fileName += "\\" + ActiveItem.FileName;
PgMng.Grow(String.Format(Face.Resources.Messages.EXPORTING_PDF, fileName), string.Empty);
diskFileDestinationOptions.DiskFileName = fileName;
options.ExportFormatType = CrystalDecisions.Shared.ExportFormatType.PortableDocFormat;
options.ExportDestinationType = CrystalDecisions.Shared.ExportDestinationType.DiskFile;
options.ExportDestinationOptions = diskFileDestinationOptions;
PgMng.Grow();
report.Export(options);
PgMng.Grow(Face.Resources.Messages.SENDING_EMAIL);
System.Net.Mail.MailMessage mail = new System.Net.Mail.MailMessage();
mail.To.Add(new MailAddress(client.Email, client.Nombre));
mail.From = new MailAddress(SettingsMng.Instance.GetSMTPMail(), company.Name);
mail.Body = String.Format(Library.Invoice.Resources.Messages.FACTURA_EMAIL_ATTACHMENT_BODY, company.Name);
mail.Subject = Library.Invoice.Resources.Messages.FACTURA_EMAIL_SUBJECT;
mail.Attachments.Add(new Attachment(fileName));
try
{
PgMng.Grow(moleQule.Face.Resources.Messages.SENDING_EMAIL, string.Empty);
EMailClient.Instance.SmtpCliente.Send(mail);
if (item.EEstado == EEstado.Abierto)
{
ChangeStateAction(EEstadoItem.Emitido);
}
PgMng.ShowInfoException("Mensaje enviado con éxito");
}
catch (Exception ex)
{
PgMng.ShowInfoException(ex.Message + Environment.NewLine + Environment.NewLine + moleQule.Library.Resources.Errors.SMTP_SETTINGS);
}
finally
{
mail.Dispose();
PgMng.FillUp();
}
}
else
{
PgMng.ShowInfoException(Face.Resources.Messages.NO_DATA_REPORTS);
PgMng.FillUp();
}
}
public int Update(CompanyInfo model)
{
return(dal.Update(model));
}
private void GrowthVsIndustry()
{
try
{
string strSQL = "Select Industry From Companies Where Symbol ='" + Ticker + "'";
MySqlCommand cmd = new MySqlCommand(strSQL, Form1.sqlConn);
object industryOBJ = cmd.ExecuteScalar();
strSQL = "Select Symbol, Name, Industry From Companies Where Industry ='" + (string)industryOBJ + "'";
cmd = new MySqlCommand(strSQL, Form1.sqlConn);
MySqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
CompanyInfo info = new CompanyInfo();
info.Symbol = reader.GetString(0);
info.Name = reader.GetString(1);
foreach (Form1.Industry industry in Enum.GetValues(typeof(Form1.Industry)))
{
if (industry.ToString() == reader.GetString(2))
{
info.Industry = industry;
}
}
CompanyInfoCollection.Add(info);
}
reader.Close();
strSQL = "Select ";
for (int x = 0; x < CompanyInfoCollection.Count - 2; x++)
{
strSQL += CompanyInfoCollection[x].Symbol + ", ";
}
strSQL += CompanyInfoCollection[CompanyInfoCollection.Count - 1].Symbol + ", DateSubmitted From StockTable2019";
cmd = new MySqlCommand(strSQL, Form1.sqlConn);
reader = cmd.ExecuteReader();
int index = 0;
while (reader.Read())
{
for (int y = 0; y < CompanyInfoCollection.Count - 1; y++)
{
DataPoint point = new DataPoint();
point.price = reader.GetDouble(y);
point.date = reader.GetDateTime(CompanyInfoCollection.Count - 1);
if (CompanyInfoCollection[y].DataPointCollection.Count > 0)
{
point.PercentChanged = ((float)point.price / (float)CompanyInfoCollection[y].DataPointCollection[CompanyInfoCollection[y].DataPointCollection.Count - 1].price - 1) * 100;
}
CompanyInfoCollection[y].DataPointCollection.Add(point);
index++;
}
}
reader.Close();
UpdateGrowthVsIndustryChart();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
public override async Task <bool> UpdateFromOnlineMusicTrackAlbumCompanyAsync(AlbumInfo album, CompanyInfo company, string language, bool cacheOnly)
{
try
{
TrackLabel labelDetail = null;
if (!string.IsNullOrEmpty(company.MusicBrainzId))
{
labelDetail = await _musicBrainzHandler.GetLabelAsync(company.MusicBrainzId, cacheOnly).ConfigureAwait(false);
}
if (labelDetail == null)
{
return(false);
}
if (labelDetail.Label == null)
{
return(false);
}
company.MusicBrainzId = labelDetail.Label.Id;
company.Name = labelDetail.Label.Name;
company.Type = CompanyAspect.COMPANY_MUSIC_LABEL;
if (!company.DataProviders.Contains(_name))
{
company.DataProviders.Add(_name);
}
return(true);
}
catch (Exception ex)
{
ServiceRegistration.Get <ILogger>().Debug("MusicBrainzWrapper: Exception while processing company {0}", ex, company.ToString());
return(false);
}
}
public ActionResult InsertCompanyInfo()
{
var response = new DBResponse();
var companyInfo = new CompanyInfo();
try
{
string filename = "";
companyInfo.Id = Convert.ToInt32(Request["Id"]);
companyInfo.Name = Convert.ToString(Request["Name"]);
companyInfo.Contact = Convert.ToString(Request["Contact"]);
companyInfo.Email = Convert.ToString(Request["Email"]);
companyInfo.Address = Convert.ToString(Request["Address"]);
if (Request.Files.Count == 0)
{
response.Id = -1;
response.StatusCode = "501";
response.StatusMessage = "Please Uplaod a file";
}
else
{
for (int i = 0; i < Request.Files.Count; i++)
{
var file = Request.Files[i];
filename = companyInfo.Id + "_" + Path.GetFileName(Request.Files[i].FileName);
var TemporaryPath = Server.MapPath(uploadPath) + filename;
file.SaveAs(TemporaryPath);
}
companyInfo.LogoLocation = filename;
var job = _dalCompany.InsertCompany(companyInfo);
if (job.Any())
{
if (job.FirstOrDefault().Id > 0)
{
response.Id = job.FirstOrDefault().Id;
response.StatusCode = "200";
response.StatusMessage = "Success";
}
else
{
response.Id = -1;
response.StatusCode = "501";
response.StatusMessage = job.FirstOrDefault().StatusMessage;
}
}
else
{
response.StatusCode = "404";
response.StatusMessage = "No available job";
}
}
}
catch (Exception ex)
{
response.Id = -1;
response.StatusCode = "500";
response.StatusMessage = ex.Message.ToString();
}
var camelCaseFormatter = new JsonSerializerSettings();
camelCaseFormatter.ContractResolver = new CamelCasePropertyNamesContractResolver();
return(Json(JsonConvert.SerializeObject(response, camelCaseFormatter), JsonRequestBehavior.AllowGet));
}
public override async Task <bool> UpdateFromOnlineMusicTrackAlbumCompanyAsync(AlbumInfo album, CompanyInfo company, string language, bool cacheOnly)
{
try
{
AudioDbAlbum albumDetail = null;
language = language ?? PreferredLanguage;
if (album.AudioDbId > 0)
{
albumDetail = await _audioDbHandler.GetAlbumAsync(album.AudioDbId, language, cacheOnly).ConfigureAwait(false);
}
if (albumDetail == null && !string.IsNullOrEmpty(album.MusicBrainzId))
{
List <AudioDbAlbum> foundAlbums = await _audioDbHandler.GetAlbumByMbidAsync(album.MusicBrainzId, language, cacheOnly).ConfigureAwait(false);
if (foundAlbums != null && foundAlbums.Count == 1)
{
//Get the album into the cache
albumDetail = await _audioDbHandler.GetAlbumAsync(foundAlbums[0].AlbumId, language, cacheOnly).ConfigureAwait(false);
}
}
if (albumDetail == null)
{
return(false);
}
if (!string.IsNullOrEmpty(albumDetail.Label) && company.MatchNames(company.Name, albumDetail.Label) && albumDetail.LabelId.HasValue)
{
company.AudioDbId = albumDetail.LabelId.Value;
company.Name = albumDetail.Label;
company.Type = CompanyAspect.COMPANY_MUSIC_LABEL;
if (!company.DataProviders.Contains(_name))
{
company.DataProviders.Add(_name);
}
return(true);
}
return(false);
}
catch (Exception ex)
{
ServiceRegistration.Get <ILogger>().Debug("TheAudioDbWrapper: Exception while processing company {0}", ex, company.ToString());
return(false);
}
}
/// <summary>
/// Function to get the current Date
/// </summary>
public void CurrentDate()
{
try
{
CompanyInfo infoComapany = new CompanyInfo();
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
FinancialYearBll bllFinancialYear = new FinancialYearBll();
infoComapany = bllCompanyCreation.CompanyView(1);
PublicVariables._dtCurrentDate = infoComapany.CurrentDate;
infoFinancialYear = bllFinancialYear.FinancialYearView(1);
PublicVariables._dtFromDate = infoFinancialYear.FromDate;
PublicVariables._dtToDate = infoFinancialYear.ToDate;
dateToolStripMenuItem.Text = PublicVariables._dtCurrentDate.ToString("dd-MMM-yyyy");
}
catch (Exception ex)
{
MessageBox.Show("MDI 2 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// 관리자 체크 check người quản lý
EmployeeInfo loginEmployee = new EmployeeInfo();
loginEmployee = (EmployeeInfo)Session["loginMember"];
if (loginEmployee == null)
{
Response.Redirect("~/login.aspx", true);
}
if (loginEmployee.ISAdmin == false)
{
Response.Redirect("~/login.aspx", true);
}
if (Page.IsPostBack)
{
// 수정하기 sửa
if (mode.Value.Equals("modify"))
{
CompanyInfo company = new CompanyInfo();
company = bll.getCompany(Request["companyCode"]);
company.CompanyCode = Convert.ToInt32(Request.QueryString["companyCode"]);
company.CompanyName = companyName.Text;
company.RegNumber1 = regNumber1.Text;
company.RegNumber2 = regNumber2.Text;
company.RegNumber3 = regNumber3.Text;
company.Phone1 = phone1.Text;
company.Phone2 = phone2.Text;
company.Phone3 = phone3.Text;
company.MasterName = masterName.Text;
company.Address = address.Text;
company.CompanyManagementNo = companyManagementNo.Text;
company.CompanyStartNo = companyStartNo.Text;
int result = bll.updateCompany(company);
Response.Redirect("companyList.aspx");
}
// 등록하기 quay lại
else
{
// 등록 여부 검사 kiểm tra có đăng ký hay không
bool exists = bll.existsComapny(regNumber1.Text, regNumber2.Text, regNumber3.Text, companyName.Text);
if (exists == true)
{
Page.RegisterStartupScript("alertMsg", JavaScriptBuilder.alert(companyName.Text + "là tên công ty đã được đăng ký. \\nHãy tìm theo tên công ty. (는 이미 등록된 업체 명입니다.\\n회사명으로 검색해 보시기 바랍니다)."));
}
else
{
// 객체를 만들어 저장 lưu object được tạo
CompanyInfo company = new CompanyInfo();
company.CompanyName = companyName.Text;
company.RegNumber1 = regNumber1.Text;
company.RegNumber2 = regNumber2.Text;
company.RegNumber3 = regNumber3.Text;
company.Phone1 = phone1.Text;
company.Phone2 = phone2.Text;
company.Phone3 = phone3.Text;
company.MasterName = masterName.Text;
company.Address = address.Text;
company.Approve = 1;
company.EmployeeCode = loginEmployee.Upnid;
company.CompanyManagementNo = companyManagementNo.Text;
company.CompanyStartNo = companyStartNo.Text;
company.EmployeeName = loginEmployee.DisplayName;
company.EmployeeDept = loginEmployee.Dep_name;
int result = bll.insertCompany(company);
bll.CreateHtml(company);
Response.Redirect("companyList.aspx");
}
}
}
else
{
if (Request.QueryString["mode"].Equals("modify"))
{
CompanyInfo company = bll.getCompany(Request.QueryString["companyCode"]);
companyName.Text = company.CompanyName;
regNumber1.Text = company.RegNumber1;
regNumber2.Text = company.RegNumber2;
regNumber3.Text = company.RegNumber3;
phone1.Text = company.Phone1;
phone2.Text = company.Phone2;
phone3.Text = company.Phone3;
masterName.Text = company.MasterName;
address.Text = company.Address;
companyManagementNo.Text = company.CompanyManagementNo;
companyStartNo.Text = company.CompanyStartNo;
lableCodeName.Text = "Sửa thông tin công ty (업체 정보 수정하기) : " + company.CompanyName;
mode.Value = Request.QueryString["mode"];
}
else
{
lableCodeName.Text = "Đăng ký công ty (업체 등록하기)";
mode.Value = Request.QueryString["mode"];
}
}
}
static void Main( string [] args )
{
StockPortfolioEntities7 spe = new StockPortfolioEntities7( );
var infos = spe.InfoCompanies;
foreach ( var ii in infos )
Console.WriteLine( ii.Name );
string oldPath = @"C:\Users\KNM\Desktop\halfway.csv";
string newerPath = @"C:\Users\KNM\Documents\GitHub\KNMFin\DebugTest\DATA\sp500tickers.csv";
String [] lines;
using ( System.IO.StreamReader sr = new System.IO.StreamReader(oldPath) )
{
string [] separator = new string [] { "\r\n" };
lines = sr.ReadToEnd( ).Split( separator, StringSplitOptions.None );
}
List<string []> items = new List<string []>( );
Dictionary<string, string []> vals = new Dictionary<string, string []>( );
string [] sep = new string [] { "," };
int dummy = 0;
foreach ( string s in lines )
{
if ( dummy == 0 ) dummy++;
else{
var t = s.Split( sep, StringSplitOptions.None );
items.Add(t);
if ( !vals.ContainsKey( t [ 0 ] ) && t[0] != string.Empty)
vals.Add( t [ 0 ], new string [] { t [ 1 ], t [ 2 ], t [ 3 ] } );
}
}
Dictionary<string, string []> hasResult = new Dictionary<string, string []>( );
List<string> noResults = new List<string>( );
HashSet<CompanyInfo> companyInfos = new HashSet<CompanyInfo>( );
// lines = GetDJIATickers( );
CompanyInfo ci;
int cID = spe.InfoCompanies.Count( );
int every50 = 0;
foreach ( KeyValuePair<string, string[]> kvp in vals )
{
if ( kvp.Key == null || kvp.Key.Replace(" ", "") == string.Empty ) continue;
ci = new CompanyInfo( kvp.Key, true );
if ( ci.Ticker != null )
{
var icQ = spe.InfoCompanies.Where( i => i.Ticker.ToUpper() == ci.Ticker.ToUpper()).FirstOrDefault();
InfoCompany ic;
if ( icQ == null)
{
ic = new InfoCompany( );
ic.Name = ci.Name;
if ( ci.Name.Length > 150 ) ic.Name = ic.Name.Substring( 0, 150 );
ic.Ticker = ci.Ticker;
}
else
{
ic = icQ;
}
if ( ci.Exchange != null)
{
var exc = spe.InfoExchanges.Where( i => i.Name == ci.Exchange ).FirstOrDefault( );
if ( exc == null){
ic.InfoExchanges.Add( new InfoExchange { Name = ci.Exchange } );
spe.SaveChanges( );
}
else
{
ic.InfoExchanges.Add( exc );
}
if ( ci.KeyStats.Count( ) > 0 )
{
int i = 0;
foreach ( KeyStatItems ks in ci.KeyStats )
{
bool annualorQ = i == 0 ? false : true;
KeyAccountingStat ksDB;
var kasQuery = spe.KeyAccountingStats.Where( j => j.Annual == annualorQ && j.CompanyID == ic.ID ).FirstOrDefault( );
if ( kasQuery == null )
{
ksDB = new KeyAccountingStat( );
if ( ks.CDPscore != null )
{
if ( ks.CDPscore.Item1 != null )
ksDB.CDPScoreN = ks.CDPscore.Item1;
else
ksDB.CDPScoreN = null;
if ( ks.CDPscore.Item2 != null )
ksDB.CDPScoreL = ks.CDPscore.Item2;
else
ksDB.CDPScoreL = null;
}
else
{
ksDB.CDPScoreN = null;
ksDB.CDPScoreL = null;
}
ksDB.Annual = i == 0 ? false : true;
ksDB.EBITDMargin = ks.EBITDmargin;
ksDB.Employees = (int?)ks.Employees;
ksDB.NetProfitMargin = ks.NetProfitMargin;
ksDB.OperatingMargin = ks.OperatingMargin;
ksDB.Period = DateTime.Now;
ksDB.ReturnOnAverageAssets = ks.ReturnOnAverageAssets;
ksDB.ReturnOnAverageEquity = ks.ReturnOnAverageEquity;
ic.KeyAccountingStats.Add( ksDB );
}
i++;
}
}
if(ic.Name == "Uranium Resources, Inc.")
{
var dbb = 1;
}
// TODO: Add update case
if ( ic.FinancialSnapshots.Count > 0 )
{
}
else
{
var fss = new FinancialSnapshot( );
fss.QueryDate = DateTime.Now;
// Nons-sensical value if this condition is false
if(ci.Beta < 100)
fss.Beta = (decimal?)ci.Beta;
fss.ClosePrice = (decimal?)ci.Close;
fss.OpenPrice = (decimal?)ci.Open;
fss.Dividend = (decimal?)ci.Dividend;
fss.DividendYield = (decimal?)ci.DividendYield;
fss.EarningsPerShare = (decimal?)ci.EarningsPerShare;
fss.FiftyTwoWeekHigh = (decimal?)ci.FiftyTwoWeekHigh;
fss.FiftyTwoWeekLow = (decimal?)ci.FiftyTwoWeekLow;
fss.InstitutionalOwnership = (decimal?)ci.InstitutionalOwnership;
fss.MarketCap = (decimal?)ci.MarketCap;
fss.PriceEarnings = (decimal?)ci.PriceEarnings;
fss.RangeHigh = (decimal?)ci.RangeHigh;
fss.RangeLow = (decimal?)ci.RangeLow;
fss.Shares = (decimal?)ci.Shares;
fss.VolumeAverage = (decimal?)ci.VolumeAverage;
fss.VolumeDaily = (decimal?)ci.VolumeTotal;
ic.FinancialSnapshots.Add( fss );
}
if ( ci.BalanceSheets != null )
{
foreach ( KNMFin.Google.BalanceSheet bs in ci.BalanceSheets )
{
if ( ic.BalanceSheets.Where( i => i.PeriodEnd == bs.PeriodEnd && i.InfoCompanies.FirstOrDefault( ) != null ? i.InfoCompanies.FirstOrDefault( ).ID == ic.ID : false ).FirstOrDefault( ) == null )
ic.BalanceSheets.Add( balancesheetDB( bs ) );
}
}
if ( ci.IncomeStatements != null )
{
foreach ( KNMFin.Google.IncomeStatement inc in ci.IncomeStatements )
{
if ( ic.IncomeStatements.Where( i => i.PeriodEnd == inc.PeriodEnd && i.InfoCompanies.FirstOrDefault( ) != null ? i.InfoCompanies.FirstOrDefault( ).ID == ic.ID : false ).FirstOrDefault( ) == null )
ic.IncomeStatements.Add( incomestatementDB( inc, spe ) );
}
int db = 1;
}
if ( ci.CashFlowStatements != null )
{
foreach ( KNMFin.Google.CashFlowStatement cfs in ci.CashFlowStatements )
{
if ( ic.StatementOfCashFlows.Where( i => i.PeriodEnd == cfs.PeriodEnd && i.InfoCompanies.FirstOrDefault( ) != null ? i.InfoCompanies.FirstOrDefault( ).ID == ic.ID : false ).FirstOrDefault( ) == null )
ic.StatementOfCashFlows.Add( cashflowDB( cfs ) );
}
}
var industryName = kvp.Value [ 2 ];
var industryQ = spe.InfoIndustries.Where( i => i.Name == industryName ).FirstOrDefault( );
if(industryQ == null){
var iName = kvp.Value[2];
ic.InfoIndustries.Add( new InfoIndustry { Name = iName } );
try
{
spe.SaveChanges( );
}
catch(Exception ex)
{
var iex = ex.InnerException;
}
ic.InfoIndustries.Add( spe.InfoIndustries.Where( i => i.Name == iName ).FirstOrDefault( ) );
}
else{
ic.InfoIndustries.Add(industryQ);
}
var sectorName = kvp.Value [ 1 ];
var sectorQ = spe.InfoSectors.Where( i => i.Name == sectorName ).FirstOrDefault( );
if ( sectorQ == null )
{
var sName = kvp.Value [ 1 ];
ic.InfoSectors.Add( new InfoSector { Name = sName } );
spe.SaveChanges( );
}
else
{
ic.InfoSectors.Add( sectorQ );
}
}
if(icQ == null)
spe.InfoCompanies.Add( ic );
every50++;
if ( every50 == 50 )
{
every50 = 0;
try
{
spe.SaveChanges( );
Console.WriteLine( "Saving 50 results into database: " + DateTime.Now.ToShortTimeString( ) );
}
catch ( System.Data.Entity.Validation.DbEntityValidationException dbEx )
{
foreach ( var validationErrors in dbEx.EntityValidationErrors )
{
foreach ( var validationError in validationErrors.ValidationErrors )
{
Console.WriteLine( "Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage );
System.Diagnostics.Trace.TraceInformation( "Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage );
}
}
}
catch ( Exception ex )
{
var exin = ex.InnerException;
}
}
if ( !hasResult.ContainsKey( kvp.Key ) )
{
var t1 = kvp.Key;
var t2 = kvp.Value;
t2 [ 1 ] = ci.Ticker;
hasResult.Add( kvp.Key, kvp.Value );
}
}
else
{
noResults.Add( kvp.Key );
}
Console.Write( "->Processed: " + kvp.Key );
}
try
{
spe.SaveChanges( );
}
catch ( System.Data.Entity.Validation.DbEntityValidationException dbEx )
{
foreach ( var validationErrors in dbEx.EntityValidationErrors )
{
foreach ( var validationError in validationErrors.ValidationErrors )
{
Console.WriteLine( "Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage );
}
}
}
catch ( Exception ex )
{
var wutttt = ex.InnerException;
}
finally
{
using ( var writer = new StreamWriter( @"C:\users\knm\desktop\ticker_results.csv" ) )
{
foreach ( KeyValuePair<string, string []> kvp in hasResult )
{
writer.WriteLine( "{0}, {1}, {2}, {3}", kvp.Key, kvp.Value [ 0 ], kvp.Value [ 1 ], kvp.Value [ 2 ] );
}
}
using ( var writer = new StreamWriter( @"C:\users\knm\desktop\no_ticker_results.csv" ) )
{
foreach ( string s in noResults )
{
writer.WriteLine( s );
}
}
}
var wut = 1;
}
/// <summary>
/// Function for Edit
/// </summary>
public void EditFunction()
{
try
{
CompanyInfo infoCompany = new CompanyInfo();
CompanyCreationBll BllCompanyCreation = new CompanyCreationBll();
CompanyPathInfo infoCompanyPath = new CompanyPathInfo();
CompanyPathBll BllCompanyPath = new CompanyPathBll();
UserInfo infoUser = new UserInfo();
UserBll bllUser = new UserBll();
infoCompany.CompanyName = txtCompanyName.Text.Trim();
infoCompany.MailingName = txtMailingName.Text.Trim();
infoCompany.Address = txtAddress.Text.Trim();
infoCompany.Phone = txtPhoneNo.Text.Trim();
infoCompany.Mobile = txtMobile.Text.Trim();
infoCompany.EmailId = txtEmail.Text.Trim();
infoCompany.Web = txtWeb.Text.Trim();
infoCompany.Country = txtCountry.Text.Trim();
infoCompany.State = txtState.Text.Trim();
infoCompany.Pin = txtPincode.Text.Trim();
infoCompany.CurrencyId = Convert.ToDecimal(cmbCurrency.SelectedValue.ToString());
infoCompany.FinancialYearFrom = Convert.ToDateTime(txtFinancialYearFrom.Text.Trim().ToString());
infoCompany.BooksBeginingFrom = Convert.ToDateTime(txtBooksBegining.Text.Trim().ToString());
infoCompany.Tin = txtTinNo.Text.Trim();
infoCompany.Cst = txtCstNo.Text.Trim();
infoCompany.Pan = txtPanNo.Text.Trim();
infoCompany.CurrentDate = DateTime.Now;
infoCompany.Logo = logo;
infoCompany.Extra1 = string.Empty;
infoCompany.Extra2 = string.Empty;
infoCompanyPath.CompanyName = txtCompanyName.Text.Trim();
infoCompanyPath.IsDefault = cbxSetAsDefault.Checked;
strPath = Application.StartupPath + "\\Data\\" + PublicVariables._decCurrentCompanyId;
infoCompanyPath.CompanyPath = strPath;
infoCompanyPath.Extra1 = string.Empty;
infoCompanyPath.Extra2 = string.Empty;
infoCompanyPath.ExtraDate = DateTime.Now;
infoCompanyPath.CompanyId = 1;
infoCompany.CompanyId = 1;
BllCompanyCreation.CompanyEdit(infoCompany);
BllCompanyPath.CompanyPathEdit(infoCompanyPath);
Messages.UpdatedMessage();
// To set default currencyId...........In exchangeRate..//
ExchangeRateBll BllExchangeRate = new ExchangeRateBll();
ExchangeRateInfo infoExchangeRate = new ExchangeRateInfo();
infoExchangeRate.ExchangeRateId = 1;
infoExchangeRate.Date = PublicVariables._dtCurrentDate;
infoExchangeRate.CurrencyId = infoCompany.CurrencyId;
infoExchangeRate.ExtraDate = PublicVariables._dtCurrentDate;
infoExchangeRate.Narration = string.Empty;
infoExchangeRate.Rate = 1;
infoExchangeRate.Extra1 = string.Empty;
infoExchangeRate.Extra2 = string.Empty;
BllExchangeRate.ExchangeRateEdit(infoExchangeRate);
FinancialYearInfo infoFinancialYear = new FinancialYearInfo();
FinancialYearBll BllFinancialYear = new FinancialYearBll();
decimal decIdentity;
infoFinancialYear.FromDate = PublicVariables._dtFromDate;
infoFinancialYear.ToDate = PublicVariables._dtToDate;
infoFinancialYear.ExtraDate = DateTime.Now;
infoFinancialYear.Extra1 = string.Empty;
infoFinancialYear.Extra2 = string.Empty;
bool isExist = BllFinancialYear.FinancialYearExistenceCheck(PublicVariables._dtFromDate, PublicVariables._dtToDate);
if (!isExist)
{
decIdentity = BllFinancialYear.FinancialYearAddWithReturnIdentity(infoFinancialYear);
}
//===========Add companyDetails in ExternalDb =====================//
decimal decCompanyIdForTemp = PublicVariables._decCurrentCompanyId;
PublicVariables._decCurrentCompanyId = 0;
CompanyCreationBll bllExCompanyCreation = new CompanyCreationBll();
CompanyPathBll bllExCompanyPath = new CompanyPathBll();
CompanyInfo infoExCompany = new CompanyInfo();
CompanyPathInfo infoExCompanyPath = new CompanyPathInfo();
infoExCompany = infoCompany;
infoExCompanyPath = infoCompanyPath;
infoExCompany.CompanyId = decCompanyIdForTemp;
infoExCompanyPath.CompanyId = decCompanyIdForTemp;
bllExCompanyCreation.CompanyEdit(infoExCompany);
bllExCompanyPath.CompanyPathEdit(infoExCompanyPath);
PublicVariables._decCurrentCompanyId = decCompanyIdForTemp;
this.Close();
}
catch (Exception ex)
{
MessageBox.Show("CR2:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// These function is used to reset the form and clear its controlls
/// </summary>
public void Clear()
{
try
{
if (isAutomatic)
{
VoucherNumberGeneration();
txtContraVoucherDate.Focus();
}
else
{
txtVoucherNo.Text = string.Empty;
txtVoucherNo.ReadOnly = false;
}
BankOrCashComboFill(cmbBankAccount);
GridBankOrCashComboFill();
isEditMode = false;
dtpContraVoucherDate.MinDate = PublicVariables._dtFromDate;
dtpContraVoucherDate.MaxDate = PublicVariables._dtToDate;
CompanyInfo infoComapany = new CompanyInfo();
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
infoComapany = bllCompanyCreation.CompanyView(1);
DateTime dtVoucherDate = infoComapany.CurrentDate;
dtpContraVoucherDate.Value = dtVoucherDate;
txtContraVoucherDate.Text = dtVoucherDate.ToString("dd-MMM-yyyy");
dtpContraVoucherDate.Value = Convert.ToDateTime(txtContraVoucherDate.Text);
txtContraVoucherDate.Focus();
txtContraVoucherDate.SelectAll();
if (txtVoucherNo.ReadOnly)
{
txtContraVoucherDate.Focus();
}
else
{
txtVoucherNo.Focus();
}
cmbBankAccount.SelectedIndex = -1;
txtNarration.Text = string.Empty;
txtTotal.Text = string.Empty;
dgvContraVoucher.ClearSelection();
rbtnDeposit.Checked = true;
btnDelete.Enabled = false;
btnSave.Text = "Save";
dgvContraVoucher.Rows.Clear();
if (frmContraRegisterObj != null)
{
frmContraRegisterObj.Close();
}
if (frmContraReportObj != null)
{
frmContraReportObj.Close();
}
SettingsBll BllSettings = new SettingsBll();
if (BllSettings.SettingsStatusCheck("TickPrintAfterSave") == "Yes")
{
cbxPrintafterSave.Checked = true;
}
else
{
cbxPrintafterSave.Checked = false;
}
}
catch (Exception ex)
{
MessageBox.Show("CV:09" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
//Company Response
protected LoyaltyCompanyResponse CreateCompanyResponseNoError(CompanyInfo inCompanyInfo)
{
return(CreateCompanyResponse(true, "", "", LoyaltyResponseCode.Successful, inCompanyInfo));
}
public bool UpdateCompanyInfo(string recuiterId, string company, string address, string district, int cityId, string phoneNumber, string description, string logoURL)
{
if (!String.IsNullOrEmpty(company) && !String.IsNullOrEmpty(recuiterId))
{
CompanyInfo companyInfo = this.CompanyInfoRepository.Get(s => s.RecruiterID == recuiterId).FirstOrDefault();
IEnumerable<CompanyInfoCity> companyInfoCity = this.CompanyInfoCityRepository.Get(s => s.RecuiterID == recuiterId).AsEnumerable();
for (int i = 0; i < companyInfoCity.Count(); i++)
{
CompanyInfoCity cic = companyInfoCity.ElementAt(i);
cic.IsDeleted = true;
this.CompanyInfoCityRepository.Update(cic);
this.Save();
}
if (companyInfo != null)
{
companyInfo.Company = company;
companyInfo.Address = address;
companyInfo.District = district;
companyInfo.PhoneNumber = phoneNumber;
companyInfo.Description = description;
companyInfo.LogoURL = logoURL;
this.CompanyInfoRepository.Update(companyInfo);
this.Save();
if (companyInfoCity != null)
{
CompanyInfoCity cic = this.CompanyInfoCityRepository.Get(s => s.RecuiterID == recuiterId && s.CityID == cityId).FirstOrDefault();
if (cic != null)
{
cic.IsDeleted = false;
this.CompanyInfoCityRepository.Update(cic);
this.Save();
}
else
{
CreateCompanyInfoCity(recuiterId, cityId);
}
}
else if (companyInfoCity == null)
{
CreateCompanyInfoCity(recuiterId, cityId);
}
return true;
}
else
{
CompanyInfo newCompanyInfo = new CompanyInfo();
newCompanyInfo.RecruiterID = recuiterId;
newCompanyInfo.Company = company;
newCompanyInfo.Address = address;
newCompanyInfo.District = district;
newCompanyInfo.PhoneNumber = phoneNumber;
newCompanyInfo.Description = description;
newCompanyInfo.LogoURL = logoURL;
newCompanyInfo.IsVisible = false;
this.CompanyInfoRepository.Insert(newCompanyInfo);
this.Save();
CreateCompanyInfoCity(recuiterId, cityId);
return true;
}
}
return false;
}
/// <summary>
/// Function to check the Date
/// </summary>
public void CurrentDateBefore()
{
try
{
CompanyInfo infoComapany = new CompanyInfo();
//CompanySP spCompany = new CompanySP();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
DateTime sysDate = System.DateTime.Today;
PublicVariables._dtCurrentDate = sysDate;
DateTime date = new DateTime(sysDate.Year, 04, 01);
DateTime dtFromDate = new DateTime();
DateTime dtToDate = new DateTime();
if (sysDate < date)
{
dtFromDate = new DateTime(sysDate.Year - 1, 04, 01);
dtToDate = new DateTime(sysDate.Year, 03, 31);
}
else
{
dtFromDate = new DateTime(sysDate.Year, 04, 01);
dtToDate = new DateTime(sysDate.Year + 1, 03, 31);
}
PublicVariables._dtFromDate = dtFromDate;
PublicVariables._dtToDate = dtToDate;
}
catch (Exception ex)
{
MessageBox.Show("MDI 1 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
protected LoyaltyCompanyResponse CreateCompanyResponseError(string inMessage, string inDescription, LoyaltyResponseCode inResponseCode, CompanyInfo inCompanyInfo)
{
return(CreateCompanyResponse(false, inMessage, inDescription, inResponseCode, inCompanyInfo));
}
private LoyaltyCompanyResponse CreateCompanyResponse(bool inSuccesful, string inMessage, string inDescription, LoyaltyResponseCode inResponseCode, CompanyInfo inCompanyInfo)
{
return(new LoyaltyCompanyResponse(inSuccesful, inMessage, inDescription, inResponseCode, inCompanyInfo));
}
public UserInformation RemoteLoginUser(string username, string password, string hostServer)
{
var userInformation = new UserInformation
{
UserInfo = new User()
};
#region Null Validation
if (username.IsNullOrEmpty() || password.IsNullOrEmpty() || hostServer.IsNullOrEmpty())
{
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Login Failed! Reason: All the inputs are required";
userInformation.Status = _status;
return(userInformation);
}
#endregion
var stationInfo = new StationInfo
{
//Address = "",
APIAccessKey = "",
HostServerAddress = hostServer,
StationKey = "",
StationName = "",
TimeStampRegistered = DateMap.CurrentTimeStamp(),
Status = true,
};
#region Super Admin User Profile
var superUserProfileInfo = new UserProfile
{
DateLastModified = DateTime.Now.ToString("yyyy/MM/dd"),
Email = "*****@*****.**",
FirstName = "SuperAdmin",
MobileNumber = "2348036975694",
ModifiedBy = 1,
OtherNames = "",
ProfileNumber = "0001",
ResidentialAddress = "EpayPlus Limited",
Sex = 1,
Status = 1,
Surname = "Epay",
TimeLastModified = DateTime.Now.ToString("hh:mm:ss tt")
};
var superUserInfo = new User
{
Email = "*****@*****.**",
FailedPasswordAttemptCount = 0,
IsApproved = true,
IsLockedOut = false,
Password = "******",
RegisteredDateTimeStamp = DateTime.Now.ToString("yyyy/MM/dd - hh:mm:ss tt"),
RoleId = 1,
UserName = "******",
LastLockedOutTimeStamp = "",
LastLoginTimeStamp = "",
LastPasswordChangedTimeStamp = ""
};
#endregion
using (var db = _uoWork.BeginTransaction())
{
try
{
#region Remotely Connect & Login
#region Access Parameter - Authorize Access
var networkInterface = InternetHelp.GetMainNetworkInterface();
var loginParameter = new RemoteLoginParameter
{
DeviceIP = InternetHelp.GetIpAddress(networkInterface),
DeviceId = InternetHelp.GetMACAddress(),
UserName = username,
Password = password
};
#endregion
string msg;
var remoteLoginRespObj = new RemoteMessanger(RemoteProcessType.RemoteLogin, hostServer).RemoteLogin(loginParameter, out msg);
if (remoteLoginRespObj == null)
{
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Process Failed! " + (string.IsNullOrEmpty(msg) ? "Unable to register Station Information" : msg);
userInformation.Status = _status;
return(userInformation);
}
if (!remoteLoginRespObj.ResponseStatus.IsSuccessful || string.IsNullOrEmpty(remoteLoginRespObj.APIAccessKey) || remoteLoginRespObj.APIAccessKey.Length != 10)
{
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = string.IsNullOrEmpty(remoteLoginRespObj.ResponseStatus.Message.FriendlyMessage) ? "Unable to complete your request! Please try again later" : remoteLoginRespObj.ResponseStatus.Message.FriendlyMessage;
userInformation.Status = _status;
return(userInformation);
}
#endregion
#region Station Info
stationInfo.RemoteStationId = remoteLoginRespObj.ClientStationId;
stationInfo.APIAccessKey = remoteLoginRespObj.APIAccessKey;
stationInfo.StationName = remoteLoginRespObj.StationName;
stationInfo.StationKey = remoteLoginRespObj.StationId;
stationInfo.Status = Convert.ToBoolean(remoteLoginRespObj.StationStatus);
var addStationInfo = _stationInfoRepository.Add(stationInfo);
_uoWork.SaveChanges();
stationInfo.StationInfoId = addStationInfo.StationInfoId;
if (stationInfo.StationInfoId < 1)
{
db.Rollback();
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Process Failed! Unable to register Station Information";
userInformation.Status = _status;
return(userInformation);
}
#endregion
#region Company
var companyInfo = new CompanyInfo
{
StationName = remoteLoginRespObj.StationName,
StationKey = remoteLoginRespObj.StationId,
HostServerAddress = hostServer,
//Address = "",
Status = Convert.ToBoolean(remoteLoginRespObj.StationStatus),
};
var addCompanyInfo = _companyRepository.Add(companyInfo);
_uoWork.SaveChanges();
if (addCompanyInfo.CompanyInfoId < 1)
{
db.Rollback();
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Unable to save Station's profile to the database";
userInformation.Status = _status;
return(userInformation);
}
#endregion
#region User Profile
var staffRegistration = new UserProfile
{
StationInfoId = stationInfo.StationInfoId,
Surname = remoteLoginRespObj.Surname,
FirstName = remoteLoginRespObj.FirstName,
OtherNames = remoteLoginRespObj.Othernames,
ResidentialAddress = remoteLoginRespObj.ResidentialAddress,
MobileNumber = remoteLoginRespObj.MobileNumber,
Email = remoteLoginRespObj.Email,
ProfileNumber = remoteLoginRespObj.EnrollerRegId,
UserProfileRemoteId = remoteLoginRespObj.EnrollerId,
Sex = remoteLoginRespObj.Sex,
Status = remoteLoginRespObj.EnrollerStatus,
TimeLastModified = DateTime.Now.ToString("hh:mm:ss tt"),
DateLastModified = DateTime.Now.ToString("yyyy/MM/dd"),
ModifiedBy = 1
};
var userProfile = _userProfileRepository.Add(staffRegistration);
_uoWork.SaveChanges();
if (userProfile.UserProfileId < 1)
{
db.Rollback();
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Error Occurred! Unable to add new user record";
userInformation.Status = _status;
return(userInformation);
}
#endregion
#region User
var user = new User
{
UserName = username,
Password = password,
Email = remoteLoginRespObj.Email,
RoleId = 2,
IsApproved = true,
IsLockedOut = false,
FailedPasswordAttemptCount = 0,
LastLockedOutTimeStamp = "",
LastLoginTimeStamp = "",
LastPasswordChangedTimeStamp = "",
RegisteredDateTimeStamp = DateTime.Now.ToString("yyyy/MM/dd - hh:mm:ss tt")
};
var thisUser = new UserRepository().GetUser(user.UserName);
if (thisUser != null)
{
if (thisUser.UserProfileId > 0)
{
db.Rollback();
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Duplicate Error! This username already exist in local database";
userInformation.Status = _status;
return(userInformation);
}
}
user.UserCode = Crypto.HashPassword(user.Password);
user.Salt = EncryptionHelper.GenerateSalt(30, 50);
user.Password = Crypto.GenerateSalt(16);
user.IsFirstTimeLogin = true;
user.UserProfileId = userProfile.UserProfileId;
var addUser = _repository.Add(user);
_uoWork.SaveChanges();
if (addUser.UserId < 1)
{
db.Rollback();
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Error Occurred! Unable to add new user account";
userInformation.Status = _status;
return(userInformation);
}
#endregion
#region Default Admin Profiles
var check = new UserRepository().GetUser("useradmin");
if (check == null || check.UserProfileId < 1)
{
superUserInfo.UserCode = Crypto.HashPassword(superUserInfo.Password);
superUserInfo.Salt = EncryptionHelper.GenerateSalt(30, 50);
superUserInfo.Password = Crypto.GenerateSalt(16);
superUserInfo.IsFirstTimeLogin = false;
var processSuperProfile = _userProfileRepository.Add(superUserProfileInfo);
_uoWork.SaveChanges();
if (processSuperProfile.UserProfileId < 1)
{
db.Rollback();
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Error Occurred! Unable to add new user account";
userInformation.Status = _status;
return(userInformation);
}
superUserInfo.UserProfileId = processSuperProfile.UserProfileId;
var processSuperUser = _repository.Add(superUserInfo);
_uoWork.SaveChanges();
if (processSuperUser.UserId < 1)
{
db.Rollback();
_status.Message.FriendlyMessage = _status.Message.TechnicalMessage = "Error Occurred! Unable to add new user account";
userInformation.Status = _status;
return(userInformation);
}
}
#endregion
db.Commit();
user.UserProfile = userProfile;
_status.IsSuccessful = true;
userInformation.Status = _status;
userInformation.UserInfo = user;
userInformation.StationInfo = stationInfo;
return(userInformation);
}
catch (DbEntityValidationException ex)
{
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
_status.Message.FriendlyMessage = "Login Failed! Reason: " + ex.Message;
_status.Message.TechnicalMessage = "Error: " + ex.Message;
userInformation.Status = _status;
return(userInformation);
}
catch (Exception ex)
{
db.Rollback();
ErrorManager.LogApplicationError(ex.StackTrace, ex.Source, ex.Message);
_status.Message.FriendlyMessage = "Login Failed! Reason: " + ex.Message;
_status.Message.TechnicalMessage = "Error: " + ex.Message;
userInformation.Status = _status;
return(userInformation);
}
}
}
/// <summary>
/// Function to set the voucherdate
/// </summary>
public void VoucherDate()
{
try
{
dtpVoucherDate.MinDate = PublicVariables._dtFromDate;
dtpVoucherDate.MaxDate = PublicVariables._dtToDate;
CompanyInfo infoComapany = new CompanyInfo();
CompanyCreationBll bllCompanyCreation = new CompanyCreationBll();
infoComapany = bllCompanyCreation.CompanyView(1);
DateTime dtVoucherDate = infoComapany.CurrentDate;
dtpVoucherDate.Value = dtVoucherDate;
txtVoucherDate.Text = dtVoucherDate.ToString("dd-MMM-yyyy");
dtpVoucherDate.Value = Convert.ToDateTime(txtVoucherDate.Text);
txtVoucherDate.Focus();
txtVoucherDate.SelectAll();
}
catch (Exception ex)
{
MessageBox.Show("SV 05 : " + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
/// <summary>
/// Setting the check box Status
/// </summary>
public void FillSettings()
{
try
{
BarcodeSettingsInfo Info = new BarcodeSettingsBll().BarcodeSettingsView(1);
if (Info.ShowMRP == true)
{
cbxShowMrp.Checked = true;
}
else
{
cbxShowMrp.Checked = false;
}
if (Info.ShowProductCode == true)
{
rbtnShowProductCode.Checked = true;
}
else
{
rbtnShowProductName.Checked = true;
}
if (Info.ShowCompanyName == true)
{
cbxShowCompanyNAmeAs.Checked = true;
}
else
{
cbxShowCompanyNAmeAs.Checked = false;
}
if (Info.ShowPurchaseRate == true)
{
cbxShowPurchaseRate.Checked = true;
}
else
{
cbxShowPurchaseRate.Checked = false;
}
txtShowCompanyName.Text = Info.CompanyName;
if (txtShowCompanyName.Text == string.Empty)
{
CompanyInfo InfoCompany = new CompanyInfo();
//CompanySP Sp = new CompanySP();
CompanyCreationBll Bll = new CompanyCreationBll();
InfoCompany = Bll.CompanyView(1);
txtShowCompanyName.Text = InfoCompany.CompanyName;
}
txtZero.Text = Info.Zero;
txtOne.Text = Info.One;
txtTwo.Text = Info.Two;
txtThree.Text = Info.Three;
txtFour.Text = Info.Four;
txtFive.Text = Info.Five;
txtSix.Text = Info.Six;
txtSeven.Text = Info.Seven;
txtEight.Text = Info.Eight;
txtNine.Text = Info.Nine;
txtPoint.Text = Info.Point;
}
catch (Exception ex)
{
MessageBox.Show("BS4:" + ex.Message, "OpenMiracle", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
