public Boolean insertDocument(documentuc doc)
{
Boolean status = true;
string utString = "";
try
{
DocumentDB dc = new DocumentDB();
DateTime cdt = DateTime.Now;
string updateSQL = "insert into DocumentUC (UserID,Status,CreateTime,CreateUser)" +
"values (" +
"'" + doc.UserID + "'," +
doc.Status + "," +
"GETDATE()" + "," +
"'" + Login.userLoggedIn + "'" + ")";
utString = utString + updateSQL + Main.QueryDelimiter;
utString = utString +
ActivityLogDB.PrepareActivityLogQquerString("insert", "DocumentUC", "", updateSQL) +
Main.QueryDelimiter;
if (!UpdateTable.UT(utString))
{
status = false;
}
}
catch (Exception ex)
{
MessageBox.Show(this.ToString() + "-" + System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
status = false;
}
return(status);
}
public static void fillMenuItemCombo(System.Windows.Forms.ComboBox cmb)
{
cmb.Items.Clear();
try
{
DocumentDB dbrecord = new DocumentDB();
List <document> DocItems = dbrecord.getDocuments();
foreach (document doc in DocItems)
{
cmb.Items.Add(doc.DocumentID + "-" + doc.DocumentName);
}
}
catch (Exception ex)
{
MessageBox.Show("fillMenuItemCombo() : Error");
}
}
public DataGridView getDocumentlistGrid()
{
DataGridView empGgrid = new DataGridView();
try
{
DataGridViewCheckBoxColumn colChk = new DataGridViewCheckBoxColumn();
colChk.Width = 50;
colChk.Name = "Select";
colChk.HeaderText = "Select";
colChk.ReadOnly = false;
DataGridViewCellStyle dataGridViewCellStyle1 = new DataGridViewCellStyle();
dataGridViewCellStyle1.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleCenter;
dataGridViewCellStyle1.BackColor = System.Drawing.Color.LightSeaGreen;
dataGridViewCellStyle1.Font = new System.Drawing.Font("Arial", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle1.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle1.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle1.WrapMode = System.Windows.Forms.DataGridViewTriState.True;
empGgrid.EnableHeadersVisualStyles = false;
empGgrid.AllowUserToAddRows = false;
empGgrid.AllowUserToDeleteRows = false;
empGgrid.BackgroundColor = System.Drawing.SystemColors.GradientActiveCaption;
empGgrid.BorderStyle = System.Windows.Forms.BorderStyle.None;
empGgrid.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
empGgrid.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
empGgrid.ColumnHeadersHeight = 27;
empGgrid.RowHeadersVisible = false;
empGgrid.Columns.Add(colChk);
DocumentDB dbrecord = new DocumentDB();
List <document> DocItems = dbrecord.getDocuments();
empGgrid.DataSource = DocItems;
}
catch (Exception ex)
{
}
return(empGgrid);
}
public static void fillMenuItemComboNew(System.Windows.Forms.ComboBox cmb)
{
cmb.Items.Clear();
try
{
DocumentDB dbrecord = new DocumentDB();
List <document> DocItems = dbrecord.getDocuments();
foreach (document doc in DocItems)
{
Structures.ComboBoxItem cbitem =
new Structures.ComboBoxItem(doc.DocumentName, doc.DocumentID);
cmb.Items.Add(cbitem);
}
}
catch (Exception ex)
{
MessageBox.Show("fillMenuItemComboNew() : Error");
}
}
public static void fillDocumentIDCumbo(System.Windows.Forms.ComboBox cmb)
{
cmb.Items.Clear();
try
{
DocumentDB docdb = new DocumentDB();
List <document> DocList = docdb.getDocuments();
foreach (document doc in DocList)
{
if (doc.DocumentStatus == 1)
{
cmb.Items.Add(doc.DocumentID);
}
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
}
public static void fillCatalogValueComboNew2(System.Windows.Forms.ComboBox cmb, System.Windows.Forms.ComboBox cmb2, System.Windows.Forms.ComboBox cmb3, System.Windows.Forms.Label Label)
{
cmb.Items.Clear();
cmb2.Items.Clear();
cmb3.Items.Clear();
try
{
CatalogueValueDB dbrecord = new CatalogueValueDB();
List <cataloguevalue> CatalogueValues = dbrecord.getCatalogueValues().Where(W => W.catalogueID == "POType").ToList();
List <documentreceiver> ListL2 = new List <documentreceiver>();
List <documentreceiver> ListL3 = new List <documentreceiver>();
List <documentreceiver> ListL = Main.DocumentReceivers.Where(W => W.Status == 1).ToList();
OfficeDB obj2 = new OfficeDB();
DocumentDB obj3 = new DocumentDB();
var Ofices = obj2.getOffices().Where(W => W.status == 1).ToList();
string DocName = "";
foreach (var itm in ListL)
{
documentreceiver obj = new documentreceiver();
DocName = itm.DocumentID;
DocName = DocName.Replace("POSERVICEINWARD", "Service PO");
DocName = DocName.Replace("PAFSERVICEINWARD", "ServicePAF");
DocName = DocName.Replace("POPRODUCTINWARD", "Product PO");
DocName = DocName.Replace("PAFPRODUCTINWARD", "ProductPAF");
obj.DocumentName = DocName;
obj.OfficeID = itm.OfficeID;
obj.OfficeName = itm.OfficeName;
obj.DocumentID = itm.DocumentID;
ListL2.Add(obj);
}
string[] Str = new string[4];
////int i = 0;
foreach (var itm in CatalogueValues)
{
documentreceiver obj = new documentreceiver();
DocName = itm.description;
DocName = DocName.Replace("Service PO", "POSERVICEINWARD");
DocName = DocName.Replace("ServicePAF", "PAFSERVICEINWARD");
DocName = DocName.Replace("Product PO", "POPRODUCTINWARD");
DocName = DocName.Replace("ProductPAF", "PAFPRODUCTINWARD");
obj.DocumentID = DocName;
obj.DocumentName = itm.description;
ListL3.Add(obj);
}
var abcsd = from Ca in CatalogueValues
join Ll in ListL2 on Ca.description equals Ll.DocumentName
select new
{
DocumentName = Ca.description,
DocumentID = Ll.DocumentID,
Ofice = Ll.OfficeID,
OficeName = Ll.OfficeName
};
var Off = from Ca in Ofices
join Ll in abcsd on Ca.OfficeID equals Ll.Ofice
select Ca;
// cmb.Items.AddRange(ListL.ToArray());
foreach (var itm in abcsd.GroupBy(x => x.DocumentName).Select(y => y.FirstOrDefault()).ToList())
{
Structures.ComboBoxItem cbitem =
new Structures.ComboBoxItem(itm.DocumentName, itm.DocumentID);
cmb.Items.Add(cbitem);
}
var Abcd2 = abcsd.GroupBy(x => x.Ofice).Select(y => y.FirstOrDefault()).ToList();
foreach (var itm in Abcd2)
{
Structures.ComboBoxItem cbitem2 =
new Structures.ComboBoxItem(itm.OficeName, itm.Ofice);
cmb2.Items.Add(cbitem2);
}
foreach (var itm in Ofices.GroupBy(G => G.RegionID))
{
Structures.ComboBoxItem cbitem =
new Structures.ComboBoxItem(itm.Key, itm.Select(s => s.RegionName).FirstOrDefault());
cmb3.Items.Add(cbitem);
}
if (ListL.Count <= 0)
{
Label.Text = "1";
var Documents = obj3.getDocuments().Where(W => W.DocumentStatus == 1).ToList();
var results = from x in Documents
join Ll in ListL3 on x.DocumentID equals Ll.DocumentID
select new
{
DocumntId = x.DocumentID,
documntname = Ll.DocumentName
};
foreach (var itm in results)
{
Structures.ComboBoxItem cbitem =
new Structures.ComboBoxItem(itm.documntname, itm.DocumntId);
cmb.Items.Add(cbitem);
}
foreach (var itm in Ofices)
{
Structures.ComboBoxItem cbitem =
new Structures.ComboBoxItem(itm.name, itm.OfficeID);
cmb2.Items.Add(cbitem);
}
// offli = Ofices.ToList();
}
}
catch (Exception ex)
{
MessageBox.Show(System.Reflection.MethodBase.GetCurrentMethod().Name + "() : Error");
}
}