private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (BsfGlobal.FindPermission("Template Documents-Delete") == false)
{
MessageBox.Show("You don't have Rights to Template Documents-Delete");
return;
}
if (grdViewTemp.FocusedRowHandle < 0)
{
return;
}
int iTempId = Convert.ToInt32(grdViewTemp.GetRowCellValue(grdViewTemp.FocusedRowHandle, "TemplateId").ToString());
//if (oTempBL.CheckTemplateUsed(iTempId) == true)
//{
// MessageBox.Show("Template Already Used, Do not Delete");
// return;
//}
DialogResult reply = MessageBox.Show("Do you want Delete?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (reply == DialogResult.Yes)
{
CompetitorBL.DeleteTempate(iTempId);
grdViewTemp.DeleteRow(grdViewTemp.FocusedRowHandle);
}
}
public void UpdateData()
{
DataTable dtA = new DataTable();
DataTable dtM = new DataTable();
dtA = dt.GetChanges(DataRowState.Added);
dtM = dt.GetChanges(DataRowState.Modified);
if (dtA != null)
{
for (int i = 0; i < dtA.Rows.Count; i++)
{
if (dtA.Rows[i]["CompetitorName"].ToString() != "")
{
CompetitorBL.InsertCompetitorMaster(dtA.Rows[i]["CompetitorName"].ToString());
}
}
}
if (dtM != null)
{
for (int i = 0; i < dtM.Rows.Count; i++)
{
if (dtM.Rows[i]["CompetitorName"].ToString() != "")
{
CompetitorBL.UpdateCompetitorMaster(Convert.ToInt32(dtM.Rows[i]["CompetitorId"]), dtM.Rows[i]["CompetitorName"].ToString());
}
}
}
}
public void FillData()
{
dt = new DataTable();
dt = CompetitorBL.GetCompMaster();
grdComp.DataSource = dt;
grdViewComp.Columns["CompetitorId"].Visible = false;
grdViewComp.Columns["CompetitorName"].BestFit();
grdViewComp.OptionsCustomization.AllowFilter = false;
grdViewComp.OptionsBehavior.AllowIncrementalSearch = true;
grdViewComp.OptionsView.ShowAutoFilterRow = false;
grdViewComp.OptionsView.ShowViewCaption = false;
grdViewComp.OptionsView.ShowFooter = false;
grdViewComp.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
grdViewComp.OptionsSelection.InvertSelection = false;
grdViewComp.OptionsView.ColumnAutoWidth = true;
grdViewComp.Appearance.HeaderPanel.Font = new Font(grdViewComp.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewComp.Appearance.FocusedCell.BackColor = Color.Teal;
grdViewComp.Appearance.FocusedCell.ForeColor = Color.White;
grdViewComp.Appearance.FocusedRow.ForeColor = Color.Teal;
grdViewComp.Appearance.FocusedRow.BackColor = Color.White;
grdViewComp.OptionsSelection.EnableAppearanceHideSelection = false;
}
private void PopulateFlatType()
{
dtFlatType = new DataTable();
try
{
dtFlatType = CompetitorBL.GetFlatType(m_sFlatTypeId);
grdFlatType.DataSource = dtFlatType;
grdViewFlatType.Columns["FlatTypeId"].Visible = false;
grdViewFlatType.Columns["MinArea"].Visible = false;
grdViewFlatType.Columns["MaxArea"].Visible = false;
grdViewFlatType.Columns["FlatTypeName"].OptionsColumn.AllowEdit = false;
grdViewFlatType.Columns["Sel"].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
RepositoryItemCheckEdit chkSel = new RepositoryItemCheckEdit();
chkSel.CheckedChanged += chkSel_CheckedChanged;
grdViewFlatType.BestFitColumns();
grdViewFlatType.Appearance.FocusedCell.BackColor = Color.Teal;
grdViewFlatType.Appearance.FocusedCell.ForeColor = Color.White;
grdViewFlatType.Appearance.FocusedRow.ForeColor = Color.Teal;
grdViewFlatType.Appearance.FocusedRow.BackColor = Color.White;
grdViewFlatType.OptionsSelection.EnableAppearanceHideSelection = false;
}
catch (Exception e)
{
throw e;
}
}
private void PopulateFlatType()
{
DataTable dt = new DataTable();
dt = CommFun.AddNoneToDataTable(CompetitorBL.GetFlatTypeReport(m_iCCId));
cboFT.DataSource = dt;
cboFT.PopulateColumns();
cboFT.DisplayMember = "FlatTypeName";
cboFT.ValueMember = "FlatTypeId";
cboFT.ForceInitialize();
cboFT.PopulateColumns();
cboFT.Columns["FlatTypeId"].Visible = false;
cboFT.ShowFooter = false;
cboFT.ShowHeader = false;
}
public void FillData()
{
dt = new DataTable();
dt = CompetitorBL.GetFlatTypeMaster();
grdFlatType.DataSource = dt;
grdViewFlatType.Columns["FlatTypeId"].Visible = false;
grdViewFlatType.Columns["FlatTypeName"].BestFit();
grdViewFlatType.Appearance.FocusedCell.BackColor = Color.Teal;
grdViewFlatType.Appearance.FocusedCell.ForeColor = Color.White;
grdViewFlatType.Appearance.FocusedRow.ForeColor = Color.Teal;
grdViewFlatType.Appearance.FocusedRow.BackColor = Color.White;
grdViewFlatType.OptionsSelection.EnableAppearanceHideSelection = false;
}
void txtTmpName_Validating(object sender, CancelEventArgs e)
{
if (BsfGlobal.FindPermission("Template Documents-Modify") == false)
{
MessageBox.Show("You don't have Rights to Template Documents-Modify");
return;
}
TextEdit editor = (TextEdit)sender;
if (CommFun.IsNullCheck(editor.EditValue.ToString(), CommFun.datatypes.vartypestring).ToString().Trim() == "")
{
grdViewTemp.CancelUpdateCurrentRow();
return;
}
//if (BankBL.CheckListFound(oChkLstBo.CheckListId, oChkLstBo.CheckListName, m_sType) == true)
//{
// MessageBox.Show("CheckListName Already Found");
// return;
//}
if (grdViewTemp.IsNewItemRow(grdViewTemp.FocusedRowHandle) == true)
{
if (CompetitorBL.TemplateFound(editor.EditValue.ToString(), m_iCompId) == true)
{
MessageBox.Show("TemplateName Already Found");
editor.EditValue = "";
return;
}
int iTempId = CompetitorBL.InsertTempName(editor.EditValue.ToString(), m_iCompId);
grdViewTemp.SetRowCellValue(grdViewTemp.FocusedRowHandle, "TemplateName", editor.EditValue.ToString());
grdViewTemp.SetRowCellValue(grdViewTemp.FocusedRowHandle, "TemplateId", iTempId);
grdViewTemp.UpdateCurrentRow();
}
else
{
int iTempId = Convert.ToInt32(grdViewTemp.GetRowCellValue(grdViewTemp.FocusedRowHandle, "TemplateId").ToString());
CompetitorBL.UpdateTemplate(iTempId, editor.EditValue.ToString());
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (grdViewFlatType.FocusedRowHandle < 0)
{
return;
}
int iFlatTypeId = Convert.ToInt32(grdViewFlatType.GetRowCellValue(grdViewFlatType.FocusedRowHandle, "FlatTypeId").ToString());
if (CompetitorBL.CheckFlatTypeMasterUsed(iFlatTypeId) == true)
{
MessageBox.Show("FlatType Used, Do not Delete");
return;
}
DialogResult result1 = MessageBox.Show("Do you want to Delete", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
CompetitorBL.DeleteFlatTypeMaster(iFlatTypeId);
grdViewFlatType.DeleteRow(grdViewFlatType.FocusedRowHandle);
}
}
private void btnDelete_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
{
if (grdViewComp.FocusedRowHandle < 0)
{
return;
}
int iCompId = Convert.ToInt32(CommFun.IsNullCheck(grdViewComp.GetRowCellValue(grdViewComp.FocusedRowHandle, "CompetitorId"), CommFun.datatypes.vartypenumeric));
if (CompetitorBL.CheckCompMasterUsed(iCompId) == true)
{
MessageBox.Show("Competitor Used, Do not Delete");
return;
}
DialogResult result1 = MessageBox.Show("Do you want to Delete", "", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (result1 == DialogResult.Yes)
{
CompetitorBL.DeleteCompetitorMaster(iCompId);
grdViewComp.DeleteRow(grdViewComp.FocusedRowHandle);
}
}
void btnRemove_Click(object sender, EventArgs e)
{
if (grdViewTemp.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Template Documents-Remove") == false)
{
MessageBox.Show("You don't have Rights to Template Documents-Remove");
return;
}
try
{
bool bFound = Convert.ToBoolean(grdViewTemp.GetRowCellValue(grdViewTemp.FocusedRowHandle, "FileFound"));
if (bFound == false)
{
MessageBox.Show("No File Attached");
return;
}
DialogResult reply = MessageBox.Show("Do you want Remove Document?", "Delete", MessageBoxButtons.YesNo, MessageBoxIcon.Question);
if (reply == DialogResult.Yes)
{
int Id = 0;
Id = Convert.ToInt32(CommFun.IsNullCheck(grdViewTemp.GetFocusedRowCellValue("TemplateId"), CommFun.datatypes.vartypenumeric));
CompetitorBL.RemoveTempate(Id);
bool bAns = false;
grdViewTemp.SetRowCellValue(grdViewTemp.FocusedRowHandle, "FileFound", bAns);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GetReport()
{
DataSet ds = new DataSet();
DataTable dtC = new DataTable();
DataTable dtD = new DataTable();
DataTable dt = new DataTable();
decimal dTot = 0;
ds = CompetitorBL.GetReport(m_iCCId, m_iFlatTypeId);
dtC = ds.Tables["Comp"];
dtD = ds.Tables["Details"];
dt.Columns.Add("Description", typeof(string));
for (int k = 0; k < dtC.Rows.Count; k++)
{
int iComp = Convert.ToInt32(dtC.Rows[k]["CompetitorId"]);
string sColumn = "Amount" + iComp.ToString();
if (dt.Columns.Contains(sColumn) == false)
{
dt.Columns.Add(sColumn, typeof(decimal));
}
}
DataRow drDesc;
drDesc = dt.NewRow();
dt.Rows.Add("AREA");
dt.Rows.Add("BASIC PRICE / SFT");
dt.Rows.Add("BASIC AMOUNT");
dt.Rows.Add("PREFFERED LOCATION CHARGES / SFT");
dt.Rows.Add("PREFFERED LOCATION AMOUNT");
dt.Rows.Add("OPEN CAR PARK");
dt.Rows.Add("REGISTRATION & STAMP DUTY CHARGES");
dt.Rows.Add("DOCUMENTATION FEES");
dt.Rows.Add("CLUB MEMBERSHIP FEES");
dt.Rows.Add("INFRASTRUCTURE CHARGES / SFT");
dt.Rows.Add("INFRASTRUCTURE AMOUNT");
dt.Rows.Add("CMWSSB / EB DEPOSIT & INCIDENTIALS");
dt.Rows.Add("OTHER CHARGES (,)");
dt.Rows.Add("MAINTENANCE FOR (1 YEAR) @ 2.5 / SFT");
dt.Rows.Add("MAINTENANCE AMOUNT");
dt.Rows.Add("CORPUS FUND");
dt.Rows.Add("PIPED GAS");
dt.Rows.Add("CANCELLATION CHARGES");
dt.Rows.Add("TOTAL");
if (dtD.Rows.Count > 0)
{
for (int i = 0; i < dtC.Rows.Count; i++)
{
int iCompId = Convert.ToInt32(dtC.Rows[i]["CompetitorId"]);
DataView dv = new DataView(dtD);
dv.RowFilter = " CompetitorId = " + iCompId + " ";
if (dv.ToTable().Rows.Count > 0)
{
if (dt.Rows.Count > 0)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
if (j == 0)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["Area"];
}
if (j == 1)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["Rate"];
}
else if (j == 2)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["BasicPrice"]; dTot = Convert.ToDecimal(dv.ToTable().Rows[0]["BasicPrice"]);
}
else if (j == 3)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["LocationRate"];
}
else if (j == 4)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["LocationCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["LocationCharges"]);
}
else if (j == 5)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["CarparkCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["CarparkCharges"]);
}
else if (j == 6)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["RegisterCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["RegisterCharges"]);
}
else if (j == 7)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["DocumentCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["DocumentCharges"]);
}
else if (j == 8)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["ClubCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["ClubCharges"]);
}
else if (j == 9)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["InfraRate"];
}
else if (j == 10)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["InfraCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["InfraCharges"]);
}
else if (j == 11)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["CMWSSBCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["CMWSSBCharges"]);
}
else if (j == 12)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["OtherCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["OtherCharges"]);
}
else if (j == 13)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["MaintenanceRate"];
}
else if (j == 14)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["MaintenanceCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["MaintenanceCharges"]);
}
else if (j == 15)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["CorpusFundCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["CorpusFundCharges"]);
}
else if (j == 16)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["PipedGasCharges"]; dTot = dTot + Convert.ToDecimal(dv.ToTable().Rows[0]["PipedGasCharges"]);
}
else if (j == 17)
{
dt.Rows[j]["Amount" + iCompId] = dv.ToTable().Rows[0]["CancellationCharges"];
}
else if (j == 18)
{
dt.Rows[j]["Amount" + iCompId] = dTot;
}
}
}
}
}
}
grdReport.DataSource = dt;
advBandViewReport.PopulateColumns();
grdReport.ForceInitialize();
advBandViewReport.Bands.Clear();
GridBand dBand = new GridBand();
dBand.Name = "BUILDER NAME";
dBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
dBand.AppearanceHeader.Font = new Font("Tahoma", 8.25F, FontStyle.Bold);
advBandViewReport.Bands.Add(dBand);
dBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
dBand.AppearanceHeader.Font = new Font("Tahoma", 8.25F, FontStyle.Bold);
BandedGridColumn dBandC = new BandedGridColumn();
dBandC = new BandedGridColumn();
dBandC = advBandViewReport.Columns[0];
dBandC.Caption = "PROJECT NAME";
dBandC.Width = 300;
dBandC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
dBandC.AppearanceHeader.Font = new Font("Tahoma", 8.25F, FontStyle.Bold);
dBand.Columns.Add(dBandC);
dBandC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Default;
dBandC.AppearanceHeader.Font = new Font("Tahoma", 8.25F, FontStyle.Bold);
for (int i = 0; i < dtC.Rows.Count; i++)
{
int l = Convert.ToInt32(dtC.Rows[i]["CompetitorId"]);
DataView dv = new DataView(dtD);
dv.RowFilter = "CompetitorId=" + l + "";
dBand = new GridBand();
dBand.Name = dtC.Rows[i]["CompetitorName"].ToString();
dBand.Caption = "";
advBandViewReport.Bands.Add(dBand);
dBandC = new BandedGridColumn();
dBandC = advBandViewReport.Columns["Amount" + l];
dBandC.Caption = dtC.Rows[i]["ProjectName"].ToString();
dBandC.Width = 150;
dBandC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
dBandC.AppearanceHeader.Font = new Font("Tahoma", 8.25F, FontStyle.Bold);
dBandC.DisplayFormat.FormatType = DevExpress.Utils.FormatType.Numeric;
dBandC.DisplayFormat.FormatString = BsfGlobal.g_sDigitFormat;
dBand.Columns.Add(dBandC);
advBandViewReport.Columns["Amount" + l].AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
advBandViewReport.Columns["Amount" + l].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
advBandViewReport.Columns["Amount" + l].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Custom;
advBandViewReport.Columns["Amount" + l].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
dBandC.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
dBandC.AppearanceHeader.Font = new Font("Tahoma", 8.25F, FontStyle.Bold);
dBand.AppearanceHeader.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Center;
dBand.AppearanceHeader.Font = new Font("Tahoma", 8.25F, FontStyle.Bold);
}
//advBandViewReport.Columns[0].SummaryItem.SetSummary(DevExpress.Data.SummaryItemType.Custom, "Total : ");
advBandViewReport.OptionsView.ColumnAutoWidth = false;
advBandViewReport.Appearance.FocusedCell.BackColor = Color.Teal;
advBandViewReport.Appearance.FocusedCell.ForeColor = Color.White;
advBandViewReport.Appearance.FocusedRow.ForeColor = Color.Black;
advBandViewReport.Appearance.FocusedRow.BackColor = Color.Teal;
advBandViewReport.OptionsSelection.EnableAppearanceHideSelection = false;
}
public void Fill_FlatType()
{
grdFlatType.DataSource = null;
DataTable dt = new DataTable();
if (dtRtn != null && dtRtn.Rows.Count > 0)
{
dt = dtRtn;
}
else
{
dt = CompetitorBL.GetFlatTypeComp(m_iProjectId);
}
grdFlatType.DataSource = dt;
grdViewFlatType.Columns["FlatTypeId"].Visible = false;
grdViewFlatType.Columns["ProjectId"].Visible = false;
grdViewFlatType.Columns["FlatTypeName"].Width = 100;
grdViewFlatType.Columns["MinArea"].Width = 50;
grdViewFlatType.Columns["MaxArea"].Width = 50;
grdViewFlatType.Columns["FlatTypeName"].Caption = CommFun.m_sFuncName + "Type Name";
grdViewFlatType.Columns["MinArea"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewFlatType.Columns["MinArea"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewFlatType.Columns["MaxArea"].SummaryItem.SummaryType = DevExpress.Data.SummaryItemType.Sum;
grdViewFlatType.Columns["MaxArea"].SummaryItem.DisplayFormat = BsfGlobal.g_sDigitFormatS;
grdViewFlatType.Columns["FlatTypeName"].OptionsColumn.ReadOnly = true;
grdViewFlatType.Columns["FlatTypeName"].OptionsColumn.AllowEdit = false;
RepositoryItemTextEdit txtMinArea = new RepositoryItemTextEdit();
grdViewFlatType.Columns["MinArea"].ColumnEdit = txtMinArea;
txtMinArea.Mask.EditMask = BsfGlobal.g_sDigitFormat;
txtMinArea.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtMinArea.Validating += txtMinArea_Validating;
RepositoryItemTextEdit txtMaxArea = new RepositoryItemTextEdit();
grdViewFlatType.Columns["MaxArea"].ColumnEdit = txtMaxArea;
txtMaxArea.Mask.EditMask = BsfGlobal.g_sDigitFormat;
txtMaxArea.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
txtMaxArea.Validating += txtMaxArea_Validating;
grdViewFlatType.OptionsCustomization.AllowFilter = false;
grdViewFlatType.OptionsBehavior.AllowIncrementalSearch = true;
grdViewFlatType.OptionsView.ShowAutoFilterRow = false;
grdViewFlatType.OptionsView.ShowViewCaption = false;
grdViewFlatType.OptionsView.ShowFooter = true;
grdViewFlatType.OptionsSelection.MultiSelectMode = GridMultiSelectMode.CellSelect;
grdViewFlatType.OptionsSelection.InvertSelection = false;
grdViewFlatType.OptionsView.ColumnAutoWidth = true;
grdViewFlatType.Appearance.HeaderPanel.Font = new Font(grdViewFlatType.Appearance.HeaderPanel.Font, FontStyle.Bold);
grdViewFlatType.Appearance.FocusedCell.BackColor = Color.Teal;
grdViewFlatType.Appearance.FocusedCell.ForeColor = Color.White;
grdViewFlatType.Appearance.FocusedRow.ForeColor = Color.Teal;
grdViewFlatType.Appearance.FocusedRow.BackColor = Color.White;
grdViewFlatType.OptionsSelection.EnableAppearanceHideSelection = false;
}
void btnView_Click(object sender, EventArgs e)
{
string m_sExten = ""; string sFileName = "";
if (BsfGlobal.FindPermission("Template Documents-View") == false)
{
MessageBox.Show("You don't have Rights to Template Documents-View");
return;
}
if (grdViewTemp.FocusedRowHandle < 0)
{
return;
}
try
{
bool bFound = Convert.ToBoolean(CommFun.IsNullCheck(grdViewTemp.GetRowCellValue(grdViewTemp.FocusedRowHandle, "FileFound"), CommFun.datatypes.varTypeBoolean));
if (bFound == false)
{
MessageBox.Show("No File Attached");
return;
}
int iTempId = Convert.ToInt32(grdViewTemp.GetRowCellValue(grdViewTemp.FocusedRowHandle, "TemplateId").ToString());
m_sExten = oTempBL.CompGetExtension(iTempId);
byte[] imageData = CompetitorBL.GetDocTemp(iTempId);
if (imageData == null)
{
MessageBox.Show("No File Attached");
return;
}
if (m_sExten == ".doc")
{
sFileName = Application.StartupPath + "\\Temp.doc";
}
else if (m_sExten == ".pdf")
{
sFileName = Application.StartupPath + "\\Temp.pdf";
}
else if (m_sExten == ".jpg")
{
sFileName = Application.StartupPath + "\\Temp.jpg";
}
bool bAns = false;
if (File.Exists(sFileName) == true)
{
FileStream fileStream = null;
try
{
fileStream = new FileStream(sFileName, FileMode.Open);
fileStream.Close();
}
catch
{
bAns = true;
}
if (bAns == true)
{
MessageBox.Show("File Already Open, Do not View");
return;
}
}
using (FileStream fs = new FileStream(sFileName, FileMode.OpenOrCreate, FileAccess.Write))
{
fs.Write(imageData, 0, imageData.Length);
fs.Flush();
fs.Close();
}
System.Diagnostics.Process.Start(sFileName);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void PopulateGrid()
{
grdTemp.DataSource = null;
m_ldtBind = new DataTable();
m_ldtBind = CompetitorBL.GetTemplate(m_iCompId);
m_ldtBind.Columns.Add("Attach", typeof(string));
m_ldtBind.Columns.Add("Remove", typeof(string));
m_ldtBind.Columns.Add("View", typeof(string));
grdTemp.DataSource = m_ldtBind;
grdViewTemp.Columns["TemplateId"].Visible = false;
grdViewTemp.Columns["FileFound"].Visible = true;
grdViewTemp.Columns["Attach"].Visible = true;
grdViewTemp.Columns["Remove"].Visible = true;
grdViewTemp.Columns["View"].Visible = true;
RepositoryItemTextEdit txtTmpName = new RepositoryItemTextEdit();
txtTmpName.LookAndFeel.UseDefaultLookAndFeel = false;
grdViewTemp.Columns["TemplateName"].ColumnEdit = txtTmpName;
txtTmpName.Validating += txtTmpName_Validating;
RepositoryItemButtonEdit btnAttach = new RepositoryItemButtonEdit();
btnAttach.LookAndFeel.SkinName = "Blue";
btnAttach.LookAndFeel.UseDefaultLookAndFeel = false;
btnAttach.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Custom;
btnAttach.Mask.UseMaskAsDisplayFormat = true;
btnAttach.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
btnAttach.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;
btnAttach.Buttons[0].Caption = "Attach";
btnAttach.Click += new EventHandler(btnAttach_Click);
grdViewTemp.Columns["Attach"].ColumnEdit = btnAttach;
RepositoryItemButtonEdit btnRemove = new RepositoryItemButtonEdit();
btnRemove.LookAndFeel.SkinName = "Blue";
btnRemove.LookAndFeel.UseDefaultLookAndFeel = false;
btnRemove.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Custom;
btnRemove.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
btnRemove.Mask.UseMaskAsDisplayFormat = true;
btnRemove.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;
btnRemove.Buttons[0].Caption = "Remove";
btnRemove.Click += new EventHandler(btnRemove_Click);
grdViewTemp.Columns["Remove"].ColumnEdit = btnRemove;
RepositoryItemButtonEdit btnView = new RepositoryItemButtonEdit();
btnView.LookAndFeel.SkinName = "Blue";
btnView.LookAndFeel.UseDefaultLookAndFeel = false;
btnView.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Custom;
btnView.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.HideTextEditor;
btnView.Buttons[0].Kind = DevExpress.XtraEditors.Controls.ButtonPredefines.Glyph;
btnView.Buttons[0].Caption = "View Document";
btnView.Mask.UseMaskAsDisplayFormat = true;
btnView.Click += new EventHandler(btnView_Click);
grdViewTemp.Columns["View"].ColumnEdit = btnView;
grdViewTemp.Columns["TemplateName"].Width = 300;
grdViewTemp.Columns["FileFound"].Width = 50;
grdViewTemp.Columns["FileFound"].OptionsColumn.AllowEdit = false;
grdViewTemp.Columns["Attach"].Width = 100;
grdViewTemp.Columns["Remove"].Width = 100;
grdViewTemp.Columns["View"].Width = 100;
}
void btnAttach_Click(object sender, EventArgs e)
{
if (grdViewTemp.FocusedRowHandle < 0)
{
return;
}
if (BsfGlobal.FindPermission("Template Documents-Attach") == false)
{
MessageBox.Show("You don't have Rights to Template Documents-Attach");
return;
}
string sExtension = "";
m_lFDialog = new OpenFileDialog();
string strFilePath = null;
m_lFDialog.Multiselect = false;
//m_lFDialog.Filter = "Word Files (*.Docs;) (*.Doc;) (*.Docx;) |*.Docs;*.Doc;*.Docx";
m_lFDialog.Filter = "Images/PDF/DOC Files (*.Docs)|*.Docs|(*.Doc)|*.Doc|(*.pdf)|*.pdf|(*.jpg)|*.jpg|(*.png)|*.png|(*.gif)|*.gif|(*.jpeg)|*.jpeg";
retVal = m_lFDialog.ShowDialog();
if (retVal == System.Windows.Forms.DialogResult.OK)
{
strFilePath = m_lFDialog.FileName;
}
if (!string.IsNullOrEmpty(strFilePath))
{
m_limgPath = strFilePath;
m_limageData = ReadFile(strFilePath.ToString());
if (m_limageData == null)
{
return;
}
m_lsFileMode = new FileStream(m_limgPath, FileMode.Open, FileAccess.Read, FileShare.Read);
r = new StreamReader(m_lsFileMode);
Array.Resize <byte>(ref m_limageData, Convert.ToInt32(m_lsFileMode.Length));
m_lsFileMode.Read(m_limageData, 0, Convert.ToInt32(m_lsFileMode.Length));
m_lTempId = Convert.ToInt32(CommFun.IsNullCheck(grdViewTemp.GetRowCellValue(grdViewTemp.FocusedRowHandle, "TemplateId"), CommFun.datatypes.vartypenumeric));
if (m_limgPath != "")
{
string fileName = System.IO.Path.GetFileName(m_limgPath);
sExtension = Path.GetExtension(m_limgPath);
}
else
{
sExtension = "";
}
CompetitorBL.TemplateAttach(m_lTempId, m_limageData, m_lsFileMode, sExtension);
bool bAns = true;
grdViewTemp.SetRowCellValue(grdViewTemp.FocusedRowHandle, "FileFound", bAns);
m_lsFileMode.Dispose();
m_lsFileMode.Close();
}
}
