private void btnSave_Click(object sender, EventArgs e)
{
var record = new TrainingTestRecord();
record.Remark = this.rtxtRemark.Text;
record.TestDate = this.dtpTestDate.Value;
record.TestPeople = this.txtTestPeople.Text;
record.TestResult = this.txtTestResult.Text;
record.TrainingContent = this.rtxtTrainingContent.Text;
record.TrainingDate = this.dtpTrainingDate.Value;
record.TrainingDepartment = this.txtTrainingDepartment.Text;
record.TrainingType = this.txtTrainingType.Text;
var bll = new TrainingTestRecordBLL();
CResult<bool> result = new CResult<bool>(false);
if (this._isEdit) {
record.RecordID = this._currentRecordID.Value;
result = bll.UpdateTrainingTestRecord(record);
} else {
record.PeopleID = this._peopleID.Value;
result = bll.InsertTrainingTestRecord(record);
}
MessageHelper.ShowSaveDbResultMessage(result);
if (result.Code == 0) {
this.Dispose();
if (callbackEvent != null) {
callbackEvent.Invoke();
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
if (string.IsNullOrWhiteSpace(this.txtPicPath.Text) || !File.Exists(this.openFileDialog1.FileName)) {
MessageBox.Show("请选择文件！");
return;
}
var pic = new PeoplePic();
pic.PicTitle = this.txtPicTitle.Text;
pic.PicPath = this.openFileDialog1.FileName;
var bll = new PeoplePicBLL();
CResult<bool> result = new CResult<bool>(false);
if (this._isEdit) {
pic.PicID = this._currentPicID.Value;
result = bll.UpdatePeoplePic(pic);
} else {
pic.PeopleID = this._peopleID.Value;
result = bll.InsertPeoplePic(pic);
}
MessageHelper.ShowSaveDbResultMessage(result);
if (result.Code == 0) {
this.Dispose();
if (callbackEvent != null) {
callbackEvent.Invoke();
}
}
}
public static void ShowSaveDbResultMessage(CResult<bool> result)
{
if (result.Code > 0) {
MessageBox.Show(result.Message, SystemInfo.ErrorReminderStr, MessageBoxButtons.OK);
return;
} else {
MessageBox.Show(SystemInfo.SuccessReminderStr, SystemInfo.ReminderStr, MessageBoxButtons.OK);
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var record = new RewardRecord();
record.RewardDate = this.dtpRewardDate.Value;
record.RewardContent = this.rtxtRewardContent.Text;
var bll = new RewardRecordBLL();
CResult<bool> result = new CResult<bool>(false);
if (this._isEdit) {
record.RecordID = this._currentRecordID.Value;
result = bll.UpdateRewardRecord(record);
} else {
record.PeopleID = this._peopleID.Value;
result = bll.InsertRewardRecord(record);
}
MessageHelper.ShowSaveDbResultMessage(result);
if (result.Code == 0) {
this.Dispose();
if (callbackEvent != null) {
callbackEvent.Invoke();
}
}
}
private void treeView1_AfterSelect_1(object sender, TreeViewEventArgs e)
{
if (e.Node.Level == 1)
{
CItemBO oitembo = new CItemBO();
CResult oresult = new CResult();
oresult = oitembo.ReadAllItemList();
foreach (CItem oitem1 in oresult.Data as ArrayList)
{
if (oitem1.Item_ItemName == e.Node.Text)
{
txthiddenitemid.Text = oitem1.Item_OID;
txtItemName.Text = oitem1.Item_ItemName;
txtItemCode.Text = oitem1.Item_Code;
txtpprice.Text = oitem1.Item_Pprice.ToString();
txtRemarks.Text = oitem1.Remarks;
txtRQTY.Text = oitem1.Item_RQTY.ToString();
txtSprice.Text = oitem1.Item_Sprice.ToString();
if (oitem1.IsActive == "Y")
{
chkIsActive.Checked = true;
}
else
{
chkIsActive.Checked = false;
}
nupdnItemPriority.Value = oitem1.Item_Priority;
if (oitem1.ItemImage != null)
{
pbImage.Image = Image.FromStream(Helper.GetMemoryStream(oitem1.ItemImage));
}
else
{
pbImage.Image = null;
}
this.ItemImage = oitem1.ItemImage;
int i = 0;
foreach (CItemGroup oitemGroup in ddlGroupNAme.Items)
{
if (oitem1.Item_GroupID == oitemGroup.Catg_OID)
{
ddlGroupNAme.SelectedIndex = i;
break;
}
i++;
}
i = 0;
foreach (CItemType oitemType in ddlItemType.Items)
{
if (oitem1.Item_TypeID == oitemType.ITyp_OID)
{
ddlItemType.SelectedIndex = i;
break;
}
i++;
}
i = 0;
foreach (CUOM oCUOM2 in ddlUOM.Items)
{
if (oitem1.Item_UOMID == oCUOM2.UOM_OID)
{
ddlUOM.SelectedIndex = i;;
break;
}
i++;
}
FormControlMode(1);
break;
}
}
}
}
private void btnSave_Click(object sender, EventArgs e)
{
var record = new TitleWageChangeRecord();
record.ChangeType = (int)(TitleChangeType)(Enum.Parse(typeof(TitleChangeType), this.cbxChangeType.SelectedItem.ToString()));
record.AfterChangeTitle = this.txtAfterChangeTitle.Text;
if (!string.IsNullOrWhiteSpace(this.txtAfterChangeAllowance.Text)) {
record.AfterChangeAllowance = float.Parse(this.txtAfterChangeAllowance.Text);
}
if (!string.IsNullOrWhiteSpace(this.txtAfterChangeBasicWage.Text)) {
record.AfterChangeBasicWage = float.Parse(this.txtAfterChangeBasicWage.Text);
}
if (!string.IsNullOrWhiteSpace(this.txtAfterChangeYearAward.Text)) {
record.AfterChangeYearAward = float.Parse(this.txtAfterChangeYearAward.Text);
}
record.BeforeChangeTitle = this.txtBeforeChangeTitle.Text;
if (!string.IsNullOrWhiteSpace(this.txtBeforeChangeallowance.Text)) {
record.BeforeChangeAllowance = float.Parse(this.txtBeforeChangeallowance.Text);
}
if (!string.IsNullOrWhiteSpace(this.txtBeforeChangeBasicWage.Text)) {
record.BeforeChangeBasicWage = float.Parse(this.txtBeforeChangeBasicWage.Text);
}
if (!string.IsNullOrWhiteSpace(this.txtBeforeChangeYearAward.Text)) {
record.BeforeChangeYearAward = float.Parse(this.txtBeforeChangeYearAward.Text);
}
record.ChangeDate = this.dtpChangeDate.Value;
record.ContractNum = this.txtContractNum.Text;
CResult<bool> result = new CResult<bool>(false);
if (_isEdit) {
record.TitleWageChangeRecordID = this._titleWageChangeRecordID.Value;
result = new TitleWageChangeRecordBLL().UpdateTitleWageChangeRecord(record);
} else {
record.PeopleID = this._peopleID.Value;
result = new TitleWageChangeRecordBLL().InsertTitleWageChangeRecord(record);
}
MessageHelper.ShowSaveDbResultMessage(result);
if (result.Code == 0) {
this.Dispose();
if (callbackEvent != null) {
callbackEvent.Invoke();
}
}
}
public CUserManager()
{
m_oResult = new CResult();
}
private void GenerateInvoiceReport(string InvoiceID)
{
CSOBO oCSOBO = new CSOBO();
CResult oResult = new CResult();
oResult = oCSOBO.ReadInvoiceReport(InvoiceID);
if (oResult.IsSuccess)
{
DataSet ds = (DataSet)oResult.Data;
POS posdateset = new POS();
DataTable dtInv = posdateset.Invoice;
foreach (DataRow dr1 in ds.Tables[0].Rows)
{
DataRow drInv = dtInv.NewRow();
drInv["BranchName"] = dr1["BranchName"];
drInv["Address"] = dr1["Address"];
drInv["RoadNo"] = dr1["RoadNo"];
drInv["City"] = dr1["City"];
drInv["Phone"] = dr1["Phone"];
drInv["InvoiceNo"] = dr1["InvoiceNo"];
drInv["VatClnNo"] = dr1["VatClnNo"];
drInv["ItemName"] = dr1["ItemName"];
drInv["Qty"] = dr1["Qty"];
drInv["Price"] = dr1["Price"];
drInv["Amount"] = dr1["Amount"];
drInv["Discount"] = dr1["Discount"];
drInv["VATValue"] = dr1["VATValue"];
drInv["TIN"] = dr1["TIN"];
drInv["PaymentType"] = dr1["PaymentType"];
dtInv.Rows.Add(drInv);
}
if (txtDiscountAmount.Text.Trim() == "")
{
txtDiscountAmount.Text = "0";
}
rptInvoice2nd objrptInvoice = new rptInvoice2nd();
objrptInvoice.SetDataSource(dtInv);
objrptInvoice.SetParameterValue(0, float.Parse(txtDiscountAmount.Text.Trim()));
objrptInvoice.SetParameterValue(1, currentUser.User_UserName.Trim());
objrptInvoice.SetParameterValue(2, decimal.Parse(txtCustomerPaid.Text.Trim()));
objrptInvoice.SetParameterValue(3, decimal.Parse(txtChange.Text.Trim()));
objrptInvoice.PrintToPrinter(1, true, 1, 100);
//frmReportView ofrmReportView = new frmReportView();
//CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
//orptviewer.ReportSource = objrptInvoice;
//orptviewer.Size = new Size(4, 4);
//orptviewer.AutoSize = false;
//orptviewer.Show();
//ofrmReportView.Show();
// objrptInvoice.PrintToPrinter(1, true, 1, 100);
//frmReportView ofrmReportView = new frmReportView();
//CrystalReportViewer orptviewer = (CrystalReportViewer)ofrmReportView.Controls["rptviewer"];
//orptviewer.ReportSource = objrptInvoice;
//orptviewer.Size = new Size(4, 4);
//orptviewer.AutoSize = false;
//orptviewer.Show();
//ofrmReportView.Show();
}
else
{
MessageBox.Show(oResult.ErrMsg.ToString(), "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public CReportManager()
{
m_oResult = new CResult();
}
public ActionResult <string> Delete(int id)
{
CResult <string> result = _customerManager.Delete(id);
return(result.Desc);
}
public RMS.Common.ObjectModel.CResult AddCat3(RMS.Common.ObjectModel.CCategory3 p_objCategory3)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckCat3(p_objCategory3);
if (bTempFlag)
{
oResult.Message = "Category exists with this name.";
}
else
{
CResult oResult2 = GetMaxCatOrder();
if (oResult2.IsSuccess && oResult2.Data != null)
{
int iTempOrder = (int)oResult2.Data;
iTempOrder = iTempOrder + 1;
p_objCategory3.Category3Name = p_objCategory3.Category3Name.Replace("''", "'");
p_objCategory3.Category3Name = p_objCategory3.Category3Name.Replace("'", "''");
p_objCategory3.Category3Description = p_objCategory3.Category3Description.Replace("''", "'");
p_objCategory3.Category3Description = p_objCategory3.Category3Description.Replace("'", "''");
this.OpenConnection();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.AddCategory3), p_objCategory3.Category3Name, p_objCategory3.Category2ID, p_objCategory3.Category3Description, p_objCategory3.Category3TablePrice, p_objCategory3.Category3TakeAwayPrice, p_objCategory3.Category3BarPrice, p_objCategory3.Category3OrderStatus, iTempOrder, p_objCategory3.Category3ViewTable, p_objCategory3.Category3ViewBar, p_objCategory3.Category3ViewTakeAway, p_objCategory3.Rank, RMSGlobal.LogInUserName, DateTime.Now.Ticks, p_objCategory3.InitialItemQuantity, p_objCategory3.UnlimitStatus, p_objCategory3.ItemSellingIn);
this.ExecuteNonQuery(sqlCommand);
#region "Added By Baruri"
Int32 category3_Order = 0;
Int32 category2_id = 0;
Int32 category2_order = 0;
this.OpenConnection();
sqlCommand = "select cat3_order,cat2_id from category3 where cat3_id=(select max(cat3_id) from category3)";
IDataReader objcategory3ID = this.ExecuteReader(sqlCommand);
if (objcategory3ID != null)
{
if (objcategory3ID.Read())
{
category3_Order = Convert.ToInt32(objcategory3ID["cat3_order"]);
category2_id = Convert.ToInt32(objcategory3ID["cat2_id"]);
}
}
objcategory3ID.Close();
sqlCommand = "select cat2_order from category2 where cat2_id=" + category2_id;
objcategory3ID = this.ExecuteReader(sqlCommand);
if (objcategory3ID != null)
{
if (objcategory3ID.Read())
{
category2_order = Convert.ToInt32(objcategory3ID["cat2_order"]);
}
}
CResult cresultCategoryRank = CalculateCat3Rank(category2_order, category3_Order);
Int64 cateRank = Convert.ToInt64(cresultCategoryRank.Data);
objcategory3ID.Close();
sqlCommand = "update category3 set cat3_rank=" + cateRank + " where cat3_id=(select max(cat3_id) from category3)";
this.ExecuteNonQuery(sqlCommand);
this.CloseConnection();
#endregion
oResult.IsSuccess = true;
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemInsert() in CUserInfoDAO class", LogLevel.Error, "Database");
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult Cat3UpdateOrderUp(RMS.Common.ObjectModel.CCategory3 oCat, RMS.Common.ObjectModel.CCategory3 oCat2)
{
CResult oResult = new CResult();
try
{
int iTempCat2Order = 0;
CCat3Rank oTempList = new CCat3Rank();
CCat3Rank oTempList2 = new CCat3Rank();
CResult oResult4 = GetCategory2Order(oCat.Category2ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
iTempCat2Order = (int)oResult4.Data;
}
else
{
return(oResult);
}
CResult oResult2 = GetOrderCandidateSingle(oCat);
if (oResult2.IsSuccess && oResult2.Data != null)
{
oTempList = (CCat3Rank)oResult2.Data;
}
CResult oResult3 = GetOrderCandidateSingle(oCat2);
if (oResult3.IsSuccess && oResult3.Data != null)
{
oTempList2 = (CCat3Rank)oResult3.Data;
}
int i = 0;
this.OpenConnectionWithTransection();
UpdateCat3Rank(oTempList, iTempCat2Order, oCat2.Category3Order);
List <CCat4Rank> oTempCat4List = oTempList.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, oCat2.Category3Order);
}
UpdateCat3Rank(oTempList2, iTempCat2Order, oCat.Category3Order);
oTempCat4List = oTempList2.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, oCat.Category3Order);
}
CCommonConstants oConstants = ConfigManager.GetConfig <CCommonConstants>();
string sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oConstants.MaxOrderChange, oCat2.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oCat2.Category3Order, oCat.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), oCat.Category3Order, oCat2.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
oResult.IsSuccess = true;
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
return(oResult);
}
private static List <DataTable> SplitTable(DataTable table, int batchSize)
{
List <DataTable> dts = new List <DataTable>();
DataColumn[] itemcols = table.Columns.Cast <DataColumn>()
.Where(c => c.ColumnName.StartsWith("SOM"))
.Select(c => new DataColumn(c.ColumnName, c.DataType))
.ToArray();
DataColumn[] uoCols = table.Columns.Cast <DataColumn>()
.Where(c => c.ColumnName.StartsWith("SOD"))
.Select(c => new DataColumn(c.ColumnName, c.DataType))
.ToArray();
var t_SOMstr = new DataTable();
t_SOMstr.Columns.AddRange(itemcols);
var t_SODet = new DataTable();
t_SODet.Columns.AddRange(uoCols);
foreach (DataRow row in table.Rows)
{
DataRow aRow = t_SOMstr.Rows.Add();
DataRow bRow = t_SODet.Rows.Add();
foreach (DataColumn aCol in itemcols)
{
aRow.SetField(aCol, row[aCol.ColumnName]);
}
foreach (DataColumn bCol in uoCols)
{
bRow.SetField(bCol, row[bCol.ColumnName]);
}
}
// DataTable dt = new DataTable();
List <CSOMaster> items = t_SOMstr.DataTableToList <CSOMaster>();
string TobeDistinct = "SOMstr_OID";
// DataTable dtDistinct = GetDistinctRecords(t_SOMstr, TobeDistinct);
//Following function will return Distinct records for Name, City and State column.
var distinctList = from p in items
group p by new { p.SOMstr_Code } //or group by new {p.ID, p.Name, p.Whatever}
into mygroup
select mygroup.FirstOrDefault();
foreach (var item in items)
{
CSOMaster oitem = item;
CSOBO oitembo = new CSOBO();
CResult oresult = new CResult();
oitem.CreationDate = Convert.ToDateTime(t_SOMstr.Rows[0]["SOMstr_CreationDate"].ToString());
oitem.Creator = t_SOMstr.Rows[0]["SOMstr_Creator"].ToString();
oitem.UpdateBy = t_SOMstr.Rows[0]["SOMstr_UpdateBy"].ToString();
oitem.UpdateDate = Convert.ToDateTime(t_SOMstr.Rows[0]["SOMstr_UpdateDate"].ToString());
oitem.IsActive = t_SOMstr.Rows[0]["SOMstr_IsActive"].ToString();
oitem.Remarks = t_SOMstr.Rows[0]["SOMstr_Remarks"].ToString();
List <CSODetails> umos = t_SODet.DataTableToList <CSODetails>();
foreach (var sodetails in umos)
{
CSODetails ouom = sodetails;
oitem.SOMstr_DetailsList.Add(ouom);
//oresult = oitembo.CreateImport(ouom);
}
oresult = oitembo.CreateSalesImport(oitem);
}
// dts.Add(t_Item);
//dts.Add(t_UOM);
return(dts);
}
private void btnDown_Click(object sender, EventArgs e)
{
try
{
if (m_iSelectedIndex >= 0 && dgvSelectionItem.Rows.Count > m_iSelectedIndex)
{
int iTempInt = Int32.Parse(dgvSelectionItem.Rows[m_iSelectedIndex].Cells[0].Value.ToString());
int iTempInt3 = Int32.Parse(dgvSelectionItem.Rows[m_iSelectedIndex].Cells[2].Value.ToString());
CCategory4 oCat = new CCategory4();
oCat.Category4ID = iTempInt;
oCat.Category4Order = iTempInt3;
if ((m_iSelectedIndex + 1) > 0 && dgvSelectionItem.Rows.Count > (m_iSelectedIndex + 1))
{
int iTempInt2 = Int32.Parse(dgvSelectionItem.Rows[(m_iSelectedIndex + 1)].Cells[0].Value.ToString());
int iTempInt4 = Int32.Parse(dgvSelectionItem.Rows[(m_iSelectedIndex + 1)].Cells[2].Value.ToString());
int iTempIndex = m_iSelectedIndex + 1;
CCategory4 oCat2 = new CCategory4();
oCat2.Category4ID = iTempInt2;
oCat2.Category4Order = iTempInt4;
if (cmbFoodItem.SelectedValue != null)
{
int iTempInt10 = Int32.Parse(cmbFoodItem.SelectedValue.ToString());
oCat.Category3ID = iTempInt10;
oCat2.Category3ID = iTempInt10;
}
CCategoryManager oCatManager = new CCategoryManager();
CResult oResult = oCatManager.UpdateCategory4Order(oCat, oCat2, false);
if (oResult.IsSuccess)
{
if (m_bGridFlag)
{
Int32 foodItemID = Convert.ToInt32(cmbFoodItem.SelectedValue);
FillSelectedItems(foodItemID);
dgvSelectionItem.Rows[0].Selected = false;
dgvSelectionItem.Rows[iTempIndex].Selected = true;
m_iSelectedIndex = iTempIndex;
if (m_iSelectedIndex > 12)
{
dgvSelectionItem.FirstDisplayedScrollingRowIndex = m_iSelectedIndex - 12;
}
}
else
{
Int32 foodItemID = Convert.ToInt32(cmbFoodItem.SelectedValue);
FillSelectedItems(foodItemID);
dgvSelectionItem.Rows[0].Selected = false;
dgvSelectionItem.Rows[iTempIndex].Selected = true;
m_iSelectedIndex = iTempIndex;
if (m_iSelectedIndex > 12)
{
dgvSelectionItem.FirstDisplayedScrollingRowIndex = m_iSelectedIndex - 12;
}
}
}
}
}
}
catch (Exception exp)
{
MessageBox.Show(exp.Message + "Error Occured. Please contact to your administrator.",
RMSGlobal.MessageBoxTitle, MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
public void RefreshFields(CMemberAndResults Member,
COneRoundResults RouteResults,
CResult RouteResult,
CFontStyleSettings RowFontStyle,
out bool PlainStyleSetted)
{
MemberInteriorConverter.CConverterResult ConverterResult = new MemberInteriorConverter.CConverterResult(DBManagerApp.m_AppSettings.m_Settings.PlainResultsFontStyle, true);
PlainStyleSetted = true;
switch (m_CellType)
{
case enCellType.Route1:
case enCellType.Route2:
case enCellType.Sum:
switch (RouteResults.m_Round)
{
case enRounds.Qualif:
case enRounds.Qualif2:
ConverterResult = MemberInteriorConverter.Convert(Member,
RouteResult,
RouteResults.m_Round,
DBManagerApp.MainWnd.MembersFromQualif,
m_CellType,
out PlainStyleSetted);
break;
case enRounds.OneEighthFinal:
case enRounds.QuaterFinal:
case enRounds.SemiFinal:
case enRounds.Final:
ConverterResult = MemberInteriorConverter.Convert(Member,
RouteResult,
RouteResults.m_Round,
null,
m_CellType,
out PlainStyleSetted);
break;
}
break;
case enCellType.StartNumber:
if (RouteResults.m_Round == enRounds.Qualif || RouteResults.m_Round == enRounds.Qualif2)
{
ConverterResult = MemberInteriorConverter.Convert(Member,
RouteResult,
RouteResults.m_Round,
DBManagerApp.MainWnd.MembersFromQualif,
m_CellType,
out PlainStyleSetted);
}
else
{
ConverterResult = MemberInteriorConverter.Convert(Member,
RouteResult,
RouteResults.m_Round,
null,
m_CellType,
out PlainStyleSetted);
}
break;
case enCellType.SurnameAndName:
if (RouteResults.m_Round == enRounds.Qualif || RouteResults.m_Round == enRounds.Qualif2)
{
ConverterResult = MemberInteriorConverter.Convert(Member,
RouteResult,
RouteResults.m_Round,
DBManagerApp.MainWnd.MembersFromQualif,
m_CellType,
out PlainStyleSetted);
}
else
{
ConverterResult = MemberInteriorConverter.Convert(Member,
RouteResult,
RouteResults.m_Round,
null,
m_CellType,
out PlainStyleSetted);
}
break;
default:
break;
}
if (PlainStyleSetted)
{
Background = new SolidColorBrush(RowFontStyle.BackgroundColor);
Foreground = new SolidColorBrush(RowFontStyle.ForeColor);
FontWeight = RowFontStyle.FontWeight;
FontStyle = RowFontStyle.FontStyle;
}
else
{
Background = ConverterResult.Background;
Foreground = ConverterResult.Foreground;
FontWeight = ConverterResult.FontWeight;
FontStyle = ConverterResult.FontStyle;
}
}
public RMS.Common.ObjectModel.CResult Cat4UpdateOrderUp(RMS.Common.ObjectModel.CCategory4 oCat, RMS.Common.ObjectModel.CCategory4 oCat2)
{
CResult oResult = new CResult();
try
{
CCommonConstants oConstants = ConfigManager.GetConfig <CCommonConstants>();
int iTempCat2Order = 0;
int iTempCat3Order = 0;
CResult oResult4 = GetCategory2Order(oCat.Category3ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
CCat4Rank oTempCat4Rank5 = (CCat4Rank)oResult4.Data;
iTempCat2Order = oTempCat4Rank5.Category2Order;
iTempCat3Order = oTempCat4Rank5.Category3Order;
}
else
{
return(oResult);
}
this.OpenConnectionWithTransection();
CCat4Rank oTempCat4Rank7 = new CCat4Rank();
oTempCat4Rank7.Category4ID = oCat.Category4ID;
oTempCat4Rank7.Category4Order = oCat2.Category4Order;
UpdateCat4Rank(oTempCat4Rank7, iTempCat2Order, iTempCat3Order);
CCat4Rank oTempCat4Rank6 = new CCat4Rank();
oTempCat4Rank6.Category4ID = oCat2.Category4ID;
oTempCat4Rank6.Category4Order = oCat.Category4Order;
UpdateCat4Rank(oTempCat4Rank6, iTempCat2Order, iTempCat3Order);
string sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), oConstants.MaxOrderChange, oCat2.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), oCat2.Category4Order, oCat.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), oCat.Category4Order, oCat2.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
oResult.IsSuccess = true;
this.CommitTransection();
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
//throw new Exception("Exception occure at ItemDelete()", ex);
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult Cat4Update(RMS.Common.ObjectModel.CCategory4 oCat, int inCatOrder)
{
CResult oResult = new CResult();
try
{
bool bTempFlag = CheckCat4ForUpdate(oCat);
if (bTempFlag)
{
oResult.Message = "Category exists with this name.";
}
else
{
int iTempCat2Order = 0;
int iTempCat3Order = 0;
CResult oResult4 = GetCategory2Order(oCat.Category3ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
CCat4Rank oTempCat4Rank5 = (CCat4Rank)oResult4.Data;
iTempCat2Order = oTempCat4Rank5.Category2Order;
iTempCat3Order = oTempCat4Rank5.Category3Order;
}
else
{
return(oResult);
}
List <int> oTempList = new List <int>();
List <int> oTempList2 = new List <int>();
CResult oResult2 = GetOrderCandidate(oCat);
if (oResult2.IsSuccess && oResult2.Data != null)
{
oTempList = (List <int>)oResult2.Data;
}
CResult oResult3 = GetOrderCandidateLower(oCat, inCatOrder);
if (oResult3.IsSuccess && oResult3.Data != null)
{
oTempList2 = (List <int>)oResult3.Data;
}
this.OpenConnectionWithTransection();
string sSql = "";
int iTempInt = 0;
int iTempInt2 = 0;
int iTempInt3 = 0;
int i = 0;
for (i = 0; i < oTempList.Count; i++)
{
iTempInt = oTempList[i];
if (iTempInt == oCat.Category4ID)
{
CCat4Rank oTempCat4Rank5 = new CCat4Rank();
oTempCat4Rank5.Category4ID = iTempInt;
oTempCat4Rank5.Category4Order = oCat.Category4Order;
UpdateCat4Rank(oTempCat4Rank5, iTempCat2Order, iTempCat3Order);
}
else
{
iTempInt2 = oCat.Category4Order + 1 + iTempInt3;
iTempInt3 = iTempInt3 + 1;
CCat4Rank oTempCat4Rank5 = new CCat4Rank();
oTempCat4Rank5.Category4ID = iTempInt;
oTempCat4Rank5.Category4Order = iTempInt2;
UpdateCat4Rank(oTempCat4Rank5, iTempCat2Order, iTempCat3Order);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), iTempInt2, iTempInt);
this.ExecuteNonQuery(sSql);
}
}
oCat.Category4Name = oCat.Category4Name.Replace("''", "'");
oCat.Category4Name = oCat.Category4Name.Replace("'", "''");
oCat.Category4Description = oCat.Category4Description.Replace("''", "'");
oCat.Category4Description = oCat.Category4Description.Replace("'", "''");
sSql = string.Format(SqlQueries.GetQuery(Query.UpdateCategory4), oCat.Category4Name, oCat.Category3ID, oCat.Category4Description, oCat.Category4TablePrice, oCat.Category4TakeAwayPrice, oCat.Category4BarPrice, oCat.Category4OrderStatus, oCat.Category4Order, oCat.Category4ViewTable, oCat.Category4ViewBar, oCat.Category4ViewTakeAway, oCat.Category4ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sSql);
iTempInt3 = 1;
sSql = "";
for (i = 0; i < oTempList2.Count; i++)
{
iTempInt = oTempList2[i];
if (iTempInt == oCat.Category4ID)
{
CCat4Rank oTempCat4Rank5 = new CCat4Rank();
oTempCat4Rank5.Category4ID = iTempInt;
oTempCat4Rank5.Category4Order = oCat.Category4Order;
UpdateCat4Rank(oTempCat4Rank5, iTempCat2Order, iTempCat3Order);
}
else
{
iTempInt2 = inCatOrder + iTempInt3 - 1;
iTempInt3 = iTempInt3 + 1;
CCat4Rank oTempCat4Rank6 = new CCat4Rank();
oTempCat4Rank6.Category4ID = iTempInt;
oTempCat4Rank6.Category4Order = iTempInt2;
UpdateCat4Rank(oTempCat4Rank6, iTempCat2Order, iTempCat3Order);
sSql = String.Format(SqlQueries.GetQuery(Query.UpdateCategory4Order), iTempInt2, iTempInt);
this.ExecuteNonQuery(sSql);
}
}
this.CommitTransection();
oResult.IsSuccess = true;
}
//this.OpenConnection();
//string sSql = string.Format(SqlQueries.GetQuery(Query.UpdateCategory4), oCat.Category4Name, oCat.Category3ID, oCat.Category4Description, oCat.Category4TablePrice, oCat.Category4TakeAwayPrice, oCat.Category4BarPrice, oCat.Category4OrderStatus, oCat.Category4Order, oCat.Category4ViewTable, oCat.Category4ViewBar, oCat.Category4ViewTakeAway, oCat.Rank, oCat.Category4ID);
//this.ExecuteNonQuery(sSql);
//oResult.IsSuccess = true;
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
throw new Exception("Exception occure at ItemDelete()", ex);
}
finally
{
this.CloseConnection();
}
return(oResult);
}
private void btnSave_Click(object sender, EventArgs e)
{
if (txtUserName.Text.Length < 1 && txtPassword.Text.Length < 1)
{
return;
}
String sTempUser = txtUserName.Text.Trim();
String sTempPass = txtPassword.Text.Trim();
int iTempType = ((CComboBoxItem)cmbUserType.SelectedItem).Value;
String sTempGender = cmbSex.SelectedItem.ToString();
CUserInfo oUser = new CUserInfo();
oUser.UserName = sTempUser;
oUser.Password = sTempPass;
oUser.Type = iTempType;
oUser.Gender = sTempGender;
if (rdoActive.Checked)
{
oUser.Status = 1;
}
else if (rdoInActive.Checked)
{
oUser.Status = 0;
}
CUserAccess oUserAccess = new CUserAccess();
if (chkOpenDrawer.Checked)
{
oUserAccess.OpenDrawer = 1;
}
if (chkReviewTrans.Checked)
{
oUserAccess.ReviewTransaction = 1;
}
if (chkVoidTable.Checked)
{
oUserAccess.VoidTable = 1;
}
if (chkViewReport.Checked)
{
oUserAccess.ViewReport = 1;
}
if (chkTransferTable.Checked)
{
oUserAccess.TransferTable = 1;
}
if (chkTillReport.Checked)
{
oUserAccess.TillReporting = 1;
}
if (chkMergeTable.Checked)
{
oUserAccess.MergeTable = 1;
}
if (chkExitRms.Checked)
{
oUserAccess.ExitRms = 1;
}
if (chkUnlockTable.Checked)
{
oUserAccess.UnlockTable = 1;
}
if (chkBooking.Checked)
{
oUserAccess.Booking = 1;
}
if (chkUsers.Checked)
{
oUserAccess.Users = 1;
}
if (chkDeposit.Checked)
{
oUserAccess.Deposit = 1;
}
if (chkCustomer.Checked)
{
oUserAccess.Customers = 1;
}
if (chkUpdateItems.Checked)
{
oUserAccess.UpdateItems = 1;
}
if (chkRemoveItems.Checked)
{
oUserAccess.RemoveItems = 1;
}
if (chkLogRegister.Checked)
{
oUserAccess.LogRegister = 1;
}
if (chkSettings.Checked)
{
oUserAccess.SystemSettings = 1;
}
if (chkRmsAdmin.Checked)
{
oUserAccess.RmsAdminAccess = 1;
}
oUser.UserAccess = oUserAccess;
CUserManager oManager = new CUserManager();
CResult oResult = oManager.AddUser(oUser);
if (oResult.IsSuccess)
{
lblSaveStatus.Text = "User information has been saved successfully.";
lblSaveStatus.Visible = true;
}
else
{
lblSaveStatus.Text = oResult.Message;
lblSaveStatus.Visible = true;
}
}
public CItemManager()
{
m_oResult = new CResult();
}
private CResult CalculateCat3Rank(int inCat2Order, int inCat3Order)
{
CResult oResult = new CResult();
String rankNumber = "";
try
{
if (inCat2Order < 10 && inCat2Order > 0)
{
rankNumber = "00000" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 100)
{
rankNumber = "0000" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 1000)
{
rankNumber = "000" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 10000)
{
rankNumber = "00" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 100000)
{
rankNumber = "0" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 1000000)
{
rankNumber = inCat2Order.ToString().Trim();
}
if (inCat3Order < 10 && inCat3Order > 0)
{
rankNumber += "00000" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 100)
{
rankNumber += "0000" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 1000)
{
rankNumber += "000" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 10000)
{
rankNumber += "00" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 100000)
{
rankNumber += "0" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 1000000)
{
rankNumber += inCat3Order.ToString().Trim();
}
rankNumber += "000000";
Int64 iTempInt;
bool bTempFlag = Int64.TryParse(rankNumber, out iTempInt);
if (bTempFlag)
{
oResult.Data = iTempInt;
oResult.IsSuccess = true;
}
}
catch (Exception ex)
{
}
return(oResult);
}
public RMS.Common.ObjectModel.CResult Cat2Update(RMS.Common.ObjectModel.CCategory2 p_objCat2, int p_catOrder)
{
CResult objResult = new CResult();
try
{
bool blnTempFlag = CheckCat2ForUpdate(p_objCat2);
if (blnTempFlag)
{
objResult.Message = "Category exists with this name.";
}
else
{
p_objCat2.Category2Name = p_objCat2.Category2Name.Replace("''", "'");
p_objCat2.Category2Name = p_objCat2.Category2Name.Replace("'", "''");
List <CCat2Rank> objRankTempList1 = new List <CCat2Rank>();
List <CCat2Rank> objRankTempList2 = new List <CCat2Rank>();
CResult objResult3 = GetOrderCandidateLower(p_objCat2, p_catOrder);
if (objResult3.IsSuccess && objResult3.Data != null)
{
objRankTempList2 = (List <CCat2Rank>)objResult3.Data;
}
CResult oResult2 = GetOrderCandidate(p_objCat2);
if (oResult2.IsSuccess && oResult2.Data != null)
{
objRankTempList1 = (List <CCat2Rank>)oResult2.Data;
}
this.OpenConnectionWithTransection();
string sqlCommand = "";
int iTempInt2 = 0;
int iTempInt3 = 0;
int counter = 0;
for (counter = 0; counter < objRankTempList1.Count; counter++)
{
CCat2Rank oTempCat2Rank = objRankTempList1[counter];
if (oTempCat2Rank.Category2ID == p_objCat2.Category2ID)
{
iTempInt2 = p_objCat2.Category2Order;
//iTempInt3 = iTempInt3 + 1;
List <CCat3Rank> oTempCat3List = oTempCat2Rank.ChildCat3List;
List <CCat4Rank> oTempCat4List = oTempCat2Rank.ChildCat4List;
if (oTempCat3List.Count > 0)
{
UpdateChildCat3Rank(oTempCat3List, iTempInt2);
}
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempInt2);
}
}
else
{
iTempInt2 = p_objCat2.Category2Order + 1 + iTempInt3;
iTempInt3 = iTempInt3 + 1;
List <CCat3Rank> oTempCat3List = oTempCat2Rank.ChildCat3List;
List <CCat4Rank> oTempCat4List = oTempCat2Rank.ChildCat4List;
if (oTempCat3List.Count > 0)
{
UpdateChildCat3Rank(oTempCat3List, iTempInt2);
}
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempInt2);
}
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory2Order), iTempInt2, oTempCat2Rank.Category2ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
}
}
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory2), p_objCat2.Category2Name, p_objCat2.Category1ID, p_objCat2.Category2Order, p_objCat2.Category2Type, p_objCat2.Category2Color, p_objCat2.Category2ViewTable, p_objCat2.Category2ViewBar, p_objCat2.Category2ViewTakeAway, p_objCat2.Category2ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
//this.CommitTransection();
sqlCommand = "";
iTempInt3 = 1;
for (counter = 0; counter < objRankTempList2.Count; counter++)
{
CCat2Rank oTempCat2Rank = objRankTempList2[counter];
if (oTempCat2Rank.Category2ID == p_objCat2.Category2ID)
{
iTempInt2 = p_objCat2.Category2Order;
//iTempInt3 = iTempInt3 + 1;
List <CCat3Rank> oTempCat3List = oTempCat2Rank.ChildCat3List;
List <CCat4Rank> oTempCat4List = oTempCat2Rank.ChildCat4List;
if (oTempCat3List.Count > 0)
{
UpdateChildCat3Rank(oTempCat3List, iTempInt2);
}
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempInt2);
}
}
else
{
iTempInt2 = p_catOrder + iTempInt3 - 1;
iTempInt3 = iTempInt3 + 1;
List <CCat3Rank> oTempCat3List = oTempCat2Rank.ChildCat3List;
List <CCat4Rank> oTempCat4List = oTempCat2Rank.ChildCat4List;
if (oTempCat3List.Count > 0)
{
UpdateChildCat3Rank(oTempCat3List, iTempInt2);
}
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempInt2);
}
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory2Order), iTempInt2, oTempCat2Rank.Category2ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
}
}
this.CommitTransection();
objResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemDelete()", LogLevel.Error, "Database");
this.RollBackTransection();
}
finally
{
this.CloseConnection();
}
return(objResult);
}
public RMS.Common.ObjectModel.CResult Cat3Update(RMS.Common.ObjectModel.CCategory3 objFoodItem, int inCatOrder)
{
CResult objResult = new CResult();
try
{
bool bTempFlag = CheckCat3ForUpdate(objFoodItem);
if (bTempFlag)
{
objResult.Message = "Category exists with this name.";
}
else
{
List <CCat3Rank> oTempList = new List <CCat3Rank>();
List <CCat3Rank> oTempList2 = new List <CCat3Rank>();
int iTempCat2Order = 0;
CResult oResult4 = GetCategory2Order(objFoodItem.Category2ID);
if (oResult4.IsSuccess && oResult4.Data != null)
{
iTempCat2Order = (int)oResult4.Data;
}
else
{
return(objResult);
}
CResult oResult2 = GetOrderCandidate(objFoodItem);
if (oResult2.IsSuccess && oResult2.Data != null)
{
oTempList = (List <CCat3Rank>)oResult2.Data;
}
CResult oResult3 = GetOrderCandidateLower(objFoodItem, inCatOrder);
if (oResult3.IsSuccess && oResult3.Data != null)
{
oTempList2 = (List <CCat3Rank>)oResult3.Data;
}
this.OpenConnectionWithTransection();
string sqlCommand = "";
int iTempInt = 0;
int iTempInt2 = 0;
int iTempInt3 = 0;
int counter = 0;
for (counter = 0; counter < oTempList.Count; counter++)
{
CCat3Rank oTempCat3Rank = oTempList[counter];
if (oTempCat3Rank.Category3ID == objFoodItem.Category3ID)
{
iTempInt2 = objFoodItem.Category3Order;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, iTempInt2);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, objFoodItem.Category3Order);
}
}
else
{
iTempInt2 = objFoodItem.Category3Order + 1 + iTempInt3;
iTempInt3 = iTempInt3 + 1;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, iTempInt2);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, iTempInt2);
}
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), iTempInt2, oTempCat3Rank.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
}
}
objFoodItem.Category3Name = objFoodItem.Category3Name.Replace("''", "'");
objFoodItem.Category3Name = objFoodItem.Category3Name.Replace("'", "''");
objFoodItem.Category3Description = objFoodItem.Category3Description.Replace("''", "'");
objFoodItem.Category3Description = objFoodItem.Category3Description.Replace("'", "''");
sqlCommand = string.Format(SqlQueries.GetQuery(Query.UpdateCategory3), objFoodItem.Category3Name, objFoodItem.Category2ID, objFoodItem.Category3Description, objFoodItem.Category3TablePrice, objFoodItem.Category3TakeAwayPrice, objFoodItem.Category3BarPrice, objFoodItem.Category3OrderStatus, objFoodItem.Category3Order, objFoodItem.Category3ViewTable, objFoodItem.Category3ViewBar, objFoodItem.Category3ViewTakeAway, objFoodItem.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks, objFoodItem.InitialItemQuantity, objFoodItem.UnlimitStatus, objFoodItem.ItemSellingIn);
this.ExecuteNonQuery(sqlCommand);
sqlCommand = "";
iTempInt3 = 1;
for (counter = 0; counter < oTempList2.Count; counter++)
{
CCat3Rank oTempCat3Rank = oTempList2[counter];
if (oTempCat3Rank.Category3ID == objFoodItem.Category3ID)
{
iTempInt2 = objFoodItem.Category3Order;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, objFoodItem.Category3Order);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, objFoodItem.Category3Order);
}
}
else
{
iTempInt2 = inCatOrder + iTempInt3 - 1;
iTempInt3 = iTempInt3 + 1;
UpdateCat3Rank(oTempCat3Rank, iTempCat2Order, iTempInt2);
List <CCat4Rank> oTempCat4List = oTempCat3Rank.ChildCat4List;
if (oTempCat4List.Count > 0)
{
UpdateChildCat4Rank(oTempCat4List, iTempCat2Order, iTempInt2);
}
sqlCommand = String.Format(SqlQueries.GetQuery(Query.UpdateCategory3Order), iTempInt2, oTempCat3Rank.Category3ID, RMSGlobal.LogInUserName, DateTime.Now.Ticks);
this.ExecuteNonQuery(sqlCommand);
}
}
this.CommitTransection();
objResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in Cat3Update()", LogLevel.Error, "Database");
throw new Exception("Exception occure at Cat3Update()", ex);
}
finally
{
this.CloseConnection();
}
return(objResult);
}
private CResult CalculateCat4Rank(int inCat2Order, int inCat3Order, int inCat4Order)
{
CResult objResult = new CResult();
String sTempStr = "";
try
{
if (inCat2Order < 10 && inCat2Order > 0)
{
sTempStr = "00000" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 100)
{
sTempStr = "0000" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 1000)
{
sTempStr = "000" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 10000)
{
sTempStr = "00" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 100000)
{
sTempStr = "0" + inCat2Order.ToString().Trim();
}
else if (inCat2Order < 1000000)
{
sTempStr = inCat2Order.ToString().Trim();
}
else
{
}
if (inCat3Order < 10 && inCat3Order > 0)
{
sTempStr += "00000" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 100)
{
sTempStr += "0000" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 1000)
{
sTempStr += "000" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 10000)
{
sTempStr += "00" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 100000)
{
sTempStr += "0" + inCat3Order.ToString().Trim();
}
else if (inCat3Order < 1000000)
{
sTempStr += inCat3Order.ToString().Trim();
}
else
{
}
if (inCat4Order < 10 && inCat4Order > 0)
{
sTempStr += "00000" + inCat4Order.ToString().Trim();
}
else if (inCat4Order < 100)
{
sTempStr += "0000" + inCat4Order.ToString().Trim();
}
else if (inCat4Order < 1000)
{
sTempStr += "000" + inCat4Order.ToString().Trim();
}
else if (inCat4Order < 10000)
{
sTempStr += "00" + inCat4Order.ToString().Trim();
}
else if (inCat4Order < 100000)
{
sTempStr += "0" + inCat4Order.ToString().Trim();
}
else if (inCat4Order < 1000000)
{
sTempStr += inCat4Order.ToString().Trim();
}
else
{
}
Int64 iTempInt;
bool bTempFlag = Int64.TryParse(sTempStr, out iTempInt);
if (bTempFlag)
{
objResult.Data = iTempInt;
objResult.IsSuccess = true;
}
}
catch (Exception ex)
{
Console.Write(ex.Message);
}
return(objResult);
}
private CResult GetOrderCandidateLower(CCategory3 oCat, int inCatOrder)
{
CResult oResult = new CResult();
try
{
List <int> iTempList = new List <int>();
List <CCat3Rank> oTempCat3List = new List <CCat3Rank>();
if (oCat.Category3Order <= inCatOrder)
{
oResult.Data = oTempCat3List;
oResult.IsSuccess = true;
}
else
{
this.OpenConnection();
string sqlCommand = string.Format(SqlQueries.GetQuery(Query.GetCat3OrderCandidateLower), oCat.Category2ID, inCatOrder, oCat.Category3Order);
IDataReader oReader = this.ExecuteReader(sqlCommand);
if (oReader != null)
{
while (oReader.Read())
{
if (oReader["cat3_id"] != null)
{
int iTempInt = Int32.Parse(oReader["cat3_id"].ToString());
iTempList.Add(iTempInt);
}
}
oReader.Close();
for (int counter = 0; counter < iTempList.Count; counter++)
{
int iTempCat2ID = iTempList[counter];
CCat3Rank oTempCat2Rank = new CCat3Rank();
oTempCat2Rank.Category3ID = iTempCat2ID;
CResult oResult3 = GetChildCat4ByCat3(iTempCat2ID);
if (oResult3.IsSuccess && oResult3.Data != null)
{
List <CCat4Rank> oTempChildList2 = (List <CCat4Rank>)oResult3.Data;
oTempCat2Rank.ChildCat4List = oTempChildList2;
}
oTempCat3List.Add(oTempCat2Rank);
}
oResult.Data = oTempCat3List;
oResult.IsSuccess = true;
}
}
}
catch (Exception ex)
{
Logger.Write("Exception : " + ex + " in ItemGetById()", LogLevel.Error, "Database");
oResult.IsException = true;
}
finally
{
this.CloseConnection();
}
return(oResult);
}
public CResult SQLResult(string strSQLString)
{
oCExecutionDB = new CExecutionDB();
oCResult = oCExecutionDB.DataAdapterQueryRequest(strSQLString);
return(oCResult);
}
public CResult Update(CCustomer oCS)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Cust_Update";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
//
cmd.Parameters.AddWithValue("@Cust_OId", oCS.Cust_OId);
cmd.Parameters.AddWithValue("@Cust_Branch", oCS.Cust_Branch);
cmd.Parameters.AddWithValue("@Cust_Id", oCS.Cust_Id);
cmd.Parameters.AddWithValue("@Cust_Name", oCS.Cust_Name);
cmd.Parameters.AddWithValue("@Cust_CSType", oCS.Cust_CSType);
cmd.Parameters.AddWithValue("@Cust_ContactP", oCS.Cust_ContactP);
cmd.Parameters.AddWithValue("@Cust_Address", oCS.Cust_Address);
cmd.Parameters.AddWithValue("@Cust_Cell", oCS.Cust_Cell);
cmd.Parameters.AddWithValue("@Cust_Phone", oCS.Cust_Phone);
cmd.Parameters.AddWithValue("@Cust_Email", oCS.Cust_Email);
cmd.Parameters.AddWithValue("@Cust_Fax", oCS.Cust_Fax);
cmd.Parameters.AddWithValue("@Cust_Web", oCS.Cust_Web);
cmd.Parameters.AddWithValue("@Cust_IsActive", oCS.Cust_IsActive);
cmd.Parameters.AddWithValue("@Cust_DiscRate", oCS.Cust_DiscRate);
cmd.Parameters.AddWithValue("@Cust_Creator", oCS.Creator);
cmd.Parameters.AddWithValue("@Cust_CreationDate", oCS.CreationDate);
cmd.Parameters.AddWithValue("@Cust_UpdateBy", oCS.UpdateBy);
cmd.Parameters.AddWithValue("@Cust_UpdateDate", oCS.UpdateDate);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult SQLResult(string strSQLString, SqlConnection oSqlConnection, SqlTransaction oSqlTransaction)
{
oCExecutionDB = new CExecutionDB();
oCResult = oCExecutionDB.DataAdapterQueryRequest(strSQLString, oSqlConnection, oSqlTransaction);
return(oCResult);
}
/// <summary>
/// 导出单位工程文件
/// </summary>
private void Import(_Files file)
{
//判定对象类别（当前处理只能是单项工程或者单位工程）
switch (this.PutType)
{
case "单项工程":
file.ExtName = _Files.EngineeringExName;
//配置数据操作接口
//this.m_DataSource.DataInterFace = CObjectProcess.CreateDataInterface(EBObjectType.Engineering);
break;
case "单位工程":
file.ExtName = _Files.CUnitProjectExName;
//配置数据操作接口
//this.m_DataSource.DataInterFace = CObjectProcess.CreateDataInterface(EBObjectType.UnitProject);
break;
case "项目":
file.ExtName = _Files.ProjectExName;
//项目数据操作接口
//this.m_DataSource.DataInterFace = CObjectProcess.CreateDataInterface(EBObjectType.PROJECT);
break;
}
FileInfo info = new FileInfo(file.FullName);
CResult result = null;
if (IsSaveAs)
{
result = this.DataInterface.SaveAs(new FileInfo(file.FullName));
}
else
{
result = this.DataInterface.OutImport(new FileInfo(file.FullName), DataSource);
}
if (!result.Success)
{
if (result.Tag != null)
{
}
else
{
MsgBox.Alert(result.ErrorInformation);
}
}
else
{
//如果成功 此处同步 当前操作项目
if (IsSaveAs)
{
this.CurrentBusiness.Current.Files = file;
}
this.DialogResult = DialogResult.OK;
}
//this.m_DataSource.DataInterFace.DataSource = this.DataSource;
/* CResult result = new CResult(false);
* if (info.Exists)
* {
* DialogResult r = MessageBox.Show(_Prompt.文件存在覆盖, "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Information);
* if (r == DialogResult.Yes)
* {
*
* result.Data = info;
* this.bWorker_SaveAs.RunWorkerAsync(result);
* ProgressFrom from = new ProgressFrom(this.bWorker_SaveAs);
* from.ShowDialog();
* }
* }
* else
* {
* //导出当前对象文件
* result.Data = info;
* this.bWorker_SaveAs.RunWorkerAsync(result);
* ProgressFrom from = new ProgressFrom(this.bWorker_SaveAs);
* from.ShowDialog();
* }*/
}
public CResult Update(CMemberShip oMemberShip)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("Update t_Member set Member_Branch=@Member_Branch,Member_MembershipID=@Member_MembershipID,Member_Name=@Member_Name,");
sBuilder.Append("Member_Mobile=@Member_Mobile,Member_DateOfBirth=@Member_DateOfBirth,Member_FromDate=@Member_FromDate,Member_ToDate=@Member_ToDate,");
sBuilder.Append("Member_Address=@Member_Address,Member_Area=@Member_Area,Member_PostCode=@Member_PostCode,Member_Phone=@Member_Phone,");
sBuilder.Append("Member_Email=@Member_Email,Member_Occupation=@Member_Occupation,Member_FamilyMember=@Member_FamilyMember,");
sBuilder.Append("Member_UpdateBy=@Member_UpdateBy,Member_UpdateDate=@Member_UpdateDate,Member_IsActive=@Member_IsActive,Member_DiscountAmount=@Member_DiscountAmount ");
sBuilder.Append("where Member_OID=@MemberOID");
cmd.CommandText = sBuilder.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@MemberOID", oMemberShip.ID);
cmd.Parameters.AddWithValue("@Member_Branch", oMemberShip.Branch);
cmd.Parameters.AddWithValue("@Member_MembershipID", oMemberShip.MembershipID);
cmd.Parameters.AddWithValue("@Member_Name", oMemberShip.MemberName);
cmd.Parameters.AddWithValue("@Member_Mobile", oMemberShip.Mobile);
cmd.Parameters.AddWithValue("@Member_DateOfBirth", oMemberShip.DateOfBirth);
cmd.Parameters.AddWithValue("@Member_FromDate", oMemberShip.Fromdate);
cmd.Parameters.AddWithValue("@Member_ToDate", oMemberShip.Todate);
cmd.Parameters.AddWithValue("@Member_Address", oMemberShip.Address);
cmd.Parameters.AddWithValue("@Member_Area", oMemberShip.Area);
cmd.Parameters.AddWithValue("@Member_PostCode", oMemberShip.PostCode);
cmd.Parameters.AddWithValue("@Member_Phone", oMemberShip.Phone);
cmd.Parameters.AddWithValue("@Member_Email", oMemberShip.Email);
cmd.Parameters.AddWithValue("@Member_Occupation", oMemberShip.Occupation);
cmd.Parameters.AddWithValue("@Member_FamilyMember", oMemberShip.FamilyMember);
cmd.Parameters.AddWithValue("@Member_UpdateBy", oMemberShip.UpdateBy);
cmd.Parameters.AddWithValue("@Member_UpdateDate", oMemberShip.UpdateDate);
cmd.Parameters.AddWithValue("@Member_IsActive", oMemberShip.IsActiveMenber);
cmd.Parameters.AddWithValue("@Member_DiscountAmount", oMemberShip.Member_DiscountAmount);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
private void btnSaveAndPrint_Click(object sender, EventArgs e)
{
if (defaultUserMode)
{
if (ValidateToBSaveData())
{
CResult oResult = new CResult();
CSOBO oSOBO = new CSOBO();
CSOMaster oSOMaster = GetToSOFormData();
if (oSOMaster.SOMstr_DetailsList.Count > 0)
{
oResult = oSOBO.Create(oSOMaster);
if (oResult.IsSuccess)
{
//MessageBox.Show("Successfully Done. ", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
string SOMstID = (string)oResult.Data;
this.GenerateInvoiceReport(SOMstID);
this.ClearAll();
txtbarcode.Select();
this.LoadItemList();
}
else
{
MessageBox.Show(oResult.ErrMsg, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
}
}
}
else
{
// Advance Start
string m_sAdvanceConfigFileName = "AdvanceConfigAndLogFile.config";
if (ValidateToBSaveData())
{
CResult oResult = new CResult();
CSOBO oSOBO = new CSOBO();
CSOMaster oSOMaster = GetToSOFormData();
if (oSOMaster.SOMstr_DetailsList.Count > 0)
{
List <CSOMaster> oListSOMaster = new List <CSOMaster>();
System.Runtime.Serialization.IFormatter formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
if (File.Exists(m_sAdvanceConfigFileName))
{
using (Stream stream = new FileStream(m_sAdvanceConfigFileName, FileMode.Open, FileAccess.Read, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateDecryptor(baKey, baIV), CryptoStreamMode.Read);
//
oListSOMaster = (List <CSOMaster>)formatter.Deserialize(cryptoStream);
//
cryptoStream.Close();
}
}
oListSOMaster.Add(oSOMaster);
formatter = new System.Runtime.Serialization.Formatters.Binary.BinaryFormatter();
using (Stream stream = new FileStream(m_sAdvanceConfigFileName, FileMode.OpenOrCreate, FileAccess.Write, FileShare.None))
{
byte[] baKey = { 51, 208, 75, 59, 223, 134, 241, 155, 170, 229, 177, 160, 246, 71, 77, 141, 66, 7, 223, 103, 97, 80, 235, 82, 94, 107, 226, 190, 76, 94, 31, 43 };
byte[] baIV = { 142, 96, 41, 14, 206, 132, 173, 19, 12, 50, 124, 121, 42, 27, 35, 9 };
Rijndael rijndael = Rijndael.Create();
CryptoStream cryptoStream = new CryptoStream(stream, rijndael.CreateEncryptor(baKey, baIV), CryptoStreamMode.Write);
//
formatter.Serialize(cryptoStream, oListSOMaster);
//
cryptoStream.Close();
}
{
CResult oResult2 = new CResult();
CGRBO oGRBO = new CGRBO();
oResult2 = oGRBO.ReduceByItemOID(oSOMaster.SOMstr_DetailsList);
}
//this.LoadItemList();
this.GenerateInvoiceReport(oSOMaster);
this.ClearAll();
txtbarcode.Select();
}
//
}
// Advance End
}
}
public CResult Create(CMemberShip oMemberShip)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Transaction = oConnManager.BeginTransaction();
try
{
StringBuilder sBuilder = new StringBuilder();
sBuilder.Append("DECLARE @NextId NCHAR(24);");
sBuilder.Append("EXEC sp_GetNextId 'Member_OID','Member', @Member_Branch, @NextId OUTPUT;");
sBuilder.Append(" Insert into t_Member values(@NextId,@Member_Branch,");
sBuilder.Append("@Member_MembershipID,@Member_Name,@Member_Mobile,@Member_DateOfBirth,");
sBuilder.Append("@Member_FromDate,@Member_ToDate,@Member_Address,");
sBuilder.Append("@Member_Area,@Member_PostCode,@Member_Phone,@Member_Email,@Member_Occupation,@Member_FamilyMember,");
sBuilder.Append("@Member_CreatedBy,@Member_CreationDate,@Member_UpdateBy,@Member_UpdateDate,@Member_IsActive,@Member_DiscountAmount)");
cmd.CommandText = sBuilder.ToString();
cmd.CommandType = CommandType.Text;
cmd.Parameters.AddWithValue("@Member_Branch", oMemberShip.Branch);
cmd.Parameters.AddWithValue("@Member_MembershipID", oMemberShip.MembershipID);
cmd.Parameters.AddWithValue("@Member_Name", oMemberShip.MemberName);
cmd.Parameters.AddWithValue("@Member_Mobile", oMemberShip.Mobile);
cmd.Parameters.AddWithValue("@Member_DateOfBirth", oMemberShip.DateOfBirth);
cmd.Parameters.AddWithValue("@Member_FromDate", oMemberShip.Fromdate);
cmd.Parameters.AddWithValue("@Member_ToDate", oMemberShip.Todate);
cmd.Parameters.AddWithValue("@Member_Address", oMemberShip.Address);
cmd.Parameters.AddWithValue("@Member_Area", oMemberShip.Area);
cmd.Parameters.AddWithValue("@Member_PostCode", oMemberShip.PostCode);
cmd.Parameters.AddWithValue("@Member_Phone", oMemberShip.Phone);
cmd.Parameters.AddWithValue("@Member_Email", oMemberShip.Email);
cmd.Parameters.AddWithValue("@Member_Occupation", oMemberShip.Occupation);
cmd.Parameters.AddWithValue("@Member_FamilyMember", oMemberShip.FamilyMember);
cmd.Parameters.AddWithValue("@Member_CreatedBy", oMemberShip.Creator);
cmd.Parameters.AddWithValue("@Member_CreationDate", oMemberShip.CreationDate);
cmd.Parameters.AddWithValue("@Member_UpdateBy", "");
cmd.Parameters.AddWithValue("@Member_UpdateDate", "");
cmd.Parameters.AddWithValue("@Member_IsActive", 1);
cmd.Parameters.AddWithValue("@Member_DiscountAmount", oMemberShip.Member_DiscountAmount);
cmd.ExecuteNonQuery();
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
string sRollbackError = oConnManager.Rollback();
oResult.IsSuccess = false;
oResult.ErrMsg = sRollbackError.Equals("") ? oConnManager.GetErrorMessage(e) : sRollbackError;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
private void LoadBarCodeItem()
{
CResult oResult = new CResult();
CItemBO oItemBO = new CItemBO();
List <CItemSales> oSalesList = new List <CItemSales>();
if (txtbarcode.Text.Trim() != "")
{
oResult = oItemBO.ReadAllFGForSalesByBranchAndItem(currentBranch.CompBrn_OId, txtbarcode.Text.Trim());
}
else if (txtItemName.Text.Trim() != "")
{
oResult = oItemBO.ReadAllFGForSalesByBranchAndName(currentBranch.CompBrn_OId, txtItemName.Text.Trim());
}
if (oResult.IsSuccess)
{
oSalesList = (List <CItemSales>)oResult.Data;
if (oSalesList.Count > 0)
{
CItemSales oItem = (CItemSales)oSalesList[0];
if (oItem != null)
{
if (oItem.Item_Price == 0)
{
MessageBox.Show("Please set the item Seles Price!!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
//this.Close();
return;
}
if (oItem.Item_ExistQTY == 0)
{
MessageBox.Show("Sales Item Quantity is Empty!!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);
return;
}
foreach (DataGridViewRow dgvr2 in this.dgvSaleItemList.Rows)
{
if (dgvr2.Index != this.dgvSaleItemList.Rows.Count - 1)
{
if (dgvr2.Cells["chItemOId"].Value.ToString() == oItem.Item_OID)
{
dgvr2.Cells["chQty"].Value = Convert.ToString(Convert.ToInt32(dgvr2.Cells["chQty"].Value) + 1);
this.CalculateTotal();
txtbarcode.Text = "";
return;
}
}
}
this.dgvSaleItemList.Rows.Add();
DataGridViewRow dgvr = this.dgvSaleItemList.Rows[this.dgvSaleItemList.Rows.Count - 2];
dgvr.Cells["chSLNum"].Value = (this.dgvSaleItemList.Rows.Count - 1).ToString();
dgvr.Cells["chItemOId"].Value = oItem.Item_OID;
dgvr.Cells["chItemName"].Value = oItem.Item_ItemName;
dgvr.Cells["chRate"].Value = oItem.Item_Price;
dgvr.Cells["chVatPercent"].Value = oItem.Item_VatPercent;
dgvr.Cells["chUOMOID"].Value = oItem.Item_UOMOID;
dgvr.Cells["chValue"].Value = "0";
dgvr.Cells["chCurrencyOID"].Value = oItem.Item_CurrencyOID;
dgvr.Cells["chVatValue"].Value = "0";
dgvr.Cells["chQty"].Value = "1";
dgvr.Cells["cPPrice"].Value = oItem.Item_PPrice;
dgvr.Tag = oItem;
this.CalculateTotal();
this.lastSelection = LastSelected.ItemList;
dgvr.Selected = true;
this.txtDiscountperc.BackColor = Color.White;
this.txtCustomerPaid.BackColor = Color.White;
IsAddedMode = false;
}
txtbarcode.Text = "";
}
}
}
public CResult InvtIncForMT(List <CInventory> oSrcInvtList, List <CInventory> oDesInvtList)
{
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.Parameters.Clear();
cmd.Transaction = oConnManager.BeginTransaction();
try
{
cmd.CommandText = "sp_Invt_Dec";
cmd.CommandType = CommandType.StoredProcedure;
foreach (CInventory oInventory in oSrcInvtList)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Invt_OID", oInventory.Invt_OID);
cmd.Parameters.AddWithValue("@Invt_Branch", oInventory.Invt_Branch);
cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
cmd.Parameters.AddWithValue("@Invt_QTY", oInventory.Invt_QTY);
cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType);
cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
cmd.ExecuteNonQuery();
}
cmd.CommandText = "sp_Invt_Inc";
cmd.CommandType = CommandType.StoredProcedure;
foreach (CInventory oInventory in oDesInvtList)
{
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@Invt_OID", oInventory.Invt_OID);
cmd.Parameters.AddWithValue("@Invt_Branch", oInventory.Invt_Branch);
cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
cmd.Parameters.AddWithValue("@Invt_QTY", oInventory.Invt_QTY);
cmd.Parameters.AddWithValue("@Invt_InvType", oInventory.Invt_InvType);
cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
cmd.ExecuteNonQuery();
}
oConnManager.Commit();
oResult.IsSuccess = true;
}
catch (SqlException e)
{
oResult.ErrMsg = e.Message;
oResult.IsSuccess = false;
string sRollbackError = oConnManager.Rollback();
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public CResult ReadForROL(CInventory oInventory)
{
ArrayList oInventoryList = new ArrayList();
oResult = new CResult();
conn = oConnManager.GetConnection(out s_DBError);
if (conn != null)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn;
cmd.CommandText = "sp_Invt_ReadForROL";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Invt_BranchOID", oInventory.Invt_BranchOID);
cmd.Parameters.AddWithValue("@Invt_LocOID", oInventory.Invt_LocOID);
cmd.Parameters.AddWithValue("@Invt_ItemOID", oInventory.Invt_ItemOID);
DataSet ds = new DataSet();
SqlDataAdapter da = new SqlDataAdapter(cmd);
da.Fill(ds);
DataTable dt = ds.Tables[0];
foreach (DataRow dr in dt.Rows)
{
oInventoryList.Add(GetresultoInventory(dr));
}
//SqlDataReader oReader = cmd.ExecuteReader();
//if (oReader.HasRows)
//{
// while (oReader.Read())
// {
// oInventory.Invt_QTY = float.Parse(oReader["Invt_QTY"].ToString());
// }
// oReader.Close();
//}
oResult.IsSuccess = true;
oResult.Data = oInventoryList;
}
catch (SqlException e)
{
oResult.IsSuccess = false;
oResult.ErrMsg = e.Message;
}
finally
{
oConnManager.Close();
}
}
else
{
oResult.IsSuccess = false;
oResult.ErrMsg = s_DBError;
}
return(oResult);
}
public override object Convert(object[] values, Type targetType, object parameter, CultureInfo culture)
{
enCellType DestColumnType = parameter == null ? enCellType.None : (enCellType)parameter;
CResult result = values[0] as CResult;
if (values.Length == 4)
{
if (result == null || !(values[1] is byte) || !(values[2] is int) || !(values[3] is int))
{
if (result != null && result.CondFormating.HasValue && (values[1] is byte) && values[3] is int)
{ // Возможно участник стоит на старте
lock (DBManagerApp.m_AppSettings.m_SettigsSyncObj)
{
if (result.CondFormating.Value == enCondFormating.StayOnStart &&
DestColumnType != enCellType.StartNumber &&
DestColumnType != enCellType.SurnameAndName)
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.StayOnStartFontStyle, false));
}
}
}
else
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.PlainResultsFontStyle, true));
}
}
}
else if (values.Length == 2)
{
if (result == null || !(values[1] is byte))
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.PlainResultsFontStyle, true));
}
}
else
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.PlainResultsFontStyle, true));
}
enRounds Round = (enRounds)((byte)values[1]);
if (!(result == null || result.CondFormating == null))
{
lock (DBManagerApp.m_AppSettings.m_SettigsSyncObj)
{
switch (result.CondFormating.Value)
{
case enCondFormating.StayOnStart: // Находится на старте
switch (DestColumnType)
{
case enCellType.StartNumber:
case enCellType.SurnameAndName:
if (Round == enRounds.Qualif || Round == enRounds.Qualif2)
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.InvitedToStartFontStyle, false));
}
break;
case enCellType.None:
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.StayOnStartFontStyle, false));
default:
break;
}
break;
case enCondFormating.JustRecievedResult: // Только что полученный результат
if (Round == enRounds.Qualif ||
Round == enRounds.Qualif2 ||
(Round > enRounds.Qualif2 && Round <= enRounds.Final && result.ResultColumnNumber == enResultColumnNumber.Sum))
{ // Тут подсветка не нужна
break;
}
else
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.JustRecievedResultFontStyle, false));
}
case enCondFormating.Preparing: // Участник готовится
if (Round == enRounds.Qualif || Round == enRounds.Qualif2)
{
switch (DestColumnType)
{
case enCellType.StartNumber:
case enCellType.SurnameAndName:
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.PreparingFontStyle, false));
default:
break;
}
}
break;
default:
break;
}
}
}
if (values.Length == 4)
{
int RoundPlace = values[2] is int?(int)values[2] : 0;
int MembersFromQualif = values[3] is int?(int)values[3] : 0;
if (RoundPlace > 0 && RoundPlace <= MembersFromQualif)
{ // Участник проходит в следуюущий тур
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.NextRoundMembersCountFontStyle, false));
}
else
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.PlainResultsFontStyle, true));
}
}
else
{
return(ConvResultVal(DBManagerApp.m_AppSettings.m_Settings.PlainResultsFontStyle, true));
}
}
public CItemManager()
{
m_oResult = new CResult();
}
private void btnSave_Click(object sender, EventArgs e)
{
var contract = new Contract();
contract.ContractNum = this.txtContractNum.Text;
contract.ContractrType = this.cbxContractrType.SelectedIndex + 1;
contract.EndDate = this.dtpEndDate.Value;
contract.IsFirstContract = this.rbtnIsFirstContract.Checked;
if (this.dtpProbationEndDate.Parent.Visible == true) {
contract.ProbationEndDate = this.dtpProbationEndDate.Value;
}
contract.StartDate = this.dtpStartDate.Value;
var bll = new ContractBLL();
CResult<bool> result = new CResult<bool>(false);
if (this._isEdit) {
contract.ContractID = this._currentContractID.Value;
result = bll.UpdateContract(contract);
} else {
contract.PeopleID = this._peopleID.Value;
result = bll.InsertContract(contract);
}
MessageHelper.ShowSaveDbResultMessage(result);
if (result.Code == 0) {
this.Dispose();
if (callbackEvent != null) {
callbackEvent.Invoke();
}
}
}
