protected void ChangePassword_ServerClick(object sender, EventArgs e)
{
Telerik.Web.UI.RadWindowManager windowManager = new Telerik.Web.UI.RadWindowManager();
Telerik.Web.UI.RadWindow widnow1 = new Telerik.Web.UI.RadWindow();
// Set the window properties
widnow1.NavigateUrl = "~/CommonUI/ChangeTeacherPassword.aspx";
widnow1.ID = "RadWindow1";
widnow1.VisibleOnPageLoad = true; // Set this property to True for showing window from code
windowManager.Windows.Add(widnow1);
this.form1.Controls.Add(widnow1);
}
public override void InitializeCell(DataControlFieldCell cell, DataControlCellType cellType, DataControlRowState rowState, int rowIndex)
{
string s = ItemTemplate.ToString();
switch (cellType)
{
case DataControlCellType.DataCell:
System.Web.UI.Control c = new System.Web.UI.Control();
ItemTemplate.InstantiateIn(c);
cell.Controls.Add(c);
EditWindow = new RadWindow();
EditWindow.Modal = true;
EditWindow.VisibleStatusbar = false;
EditWindow.Height = 350;
EditWindow.Width = 490;
EditWindow.DestroyOnClose = false;
EditWindow.Title = "Edit Performance Indicator Metrics";
cell.Controls.Add(EditWindow);
Control.PreRender += new EventHandler(Control_PreRender);
break;
case DataControlCellType.Header:
if (!string.IsNullOrEmpty(HeaderText))
{
cell.Controls.Add(new LiteralControl(HeaderText + "<br>"));
}
EditLink = new HyperLink();
EditLink.Text = "Edit";
cell.Controls.Add(EditLink);
break;
}
}
protected void btn_import_Click(object sender, EventArgs e)
{
try
{
string strcon = null;
string strfilename1 = fu_masters.FileName;
strfilename2 = Convert.ToString(DateTime.Now.TimeOfDay) + "_" + strfilename1;
strfilename2 = strfilename2.Replace("/", "").Replace(":", ".");
if (fu_masters.HasFile)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == false)
{
System.IO.Directory.CreateDirectory(Server.MapPath("~/IMPORT_EXCEL/"));
}
fu_masters.PostedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/IMPORT_EXCEL/"), strfilename2));
string filename1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
FileInfo fileInfo = new FileInfo(filename1);
if (fileInfo.Exists)
{
string path = MapPath(strfilename1);
// string name = Path.GetFileName( path );
string ext = Path.GetExtension(path);
string type = string.Empty;
// set known types based on file extension
if (ext != null)
{
switch (ext.ToLower())
{
case ".xls":
type = "excel";
break;
case ".xlsx":
type = "excel";
break;
default:
type = string.Empty;
break;
}
}
if (type == string.Empty)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == true)
{
string path1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
System.IO.File.Delete(path1);
}
BLL.ShowMessage(this, "Please select the Excel File (Eg: Excel.xlsx). ");
return;
}
}
}
else
{
BLL.ShowMessage(this, "Please Select the File to be uploaded");
return;
}
string strpath = Server.MapPath("~/IMPORT_EXCEL/");
strpath = strpath + strfilename2;
// Getting data from excell file to dataset.
strcon = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source='" + strpath + "';" + "Extended Properties=Excel 12.0;";
OleDbConnection objConn = null;
objConn = new OleDbConnection(strcon);
objConn.Open();
DataTable dt_chk2 = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string sheetname;
if (dt_chk2 == null)
{
objConn.Close();
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
else
{
sheetname = Convert.ToString(dt_chk2.Rows[0]["TABLE_NAME"]);
}
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + sheetname + "]", strcon);
da.Fill(ds);
objConn.Close();
DataTable dt = new DataTable();
DataTable dtfail = new DataTable();
string errormsg = string.Empty;
string projecttype = null;
Int32 rowno = 0;
string columnno = null;
Boolean filestatus = true;
dtfail.Columns.Add("S.NO", typeof(Int32));
dtfail.Columns.Add("ROWNO", typeof(Int32));
dtfail.Columns.Add("COLUMNS NAMES", typeof(string));
if (!(ds.Tables[0].Columns[0].ToString().Trim() == "Name*"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (!(ds.Tables[0].Columns[1].ToString().Trim() == "Description"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (!(ds.Tables[0].Columns[2].ToString().Trim() == "Error Message"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Rows.Count == 0)
{
Delete_Excel_File();
BLL.ShowMessage(this, "Successfully processed Excel file. No Records are Imported.");
return;
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
if (ds.Tables[0].Rows[i]["Name*"].ToString().Trim() != "")
{
_obj_Smhr_Masters = new SMHR_MASTERS();
_obj_Smhr_Masters.MASTER_TYPE = control.ToUpper();
_obj_Smhr_Masters.MASTER_CODE = ds.Tables[0].Rows[i]["Name*"].ToString().Trim();
_obj_Smhr_Masters.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
_obj_Smhr_Masters.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_MasterRecords(_obj_Smhr_Masters).Rows[0]["Count"]) != "0")
{
errormsg = lblheader.Text + " with this Name Already Exists";
filestatus = false;
rowno = i + 2;
columnno = "Name*";
}
}
else
{
filestatus = false;
rowno = i + 2;
columnno = "Name*";
}
//if (!(ds.Tables[0].Rows[i]["Description"].ToString().Trim() != ""))
//{
// filestatus = false;
// rowno = i + 2;
// columnno = columnno + "," + "Description";
//}
if (filestatus == false)
{
DataRow newrow = dtfail.NewRow();
newrow["S.NO"] = dtfail.Rows.Count + 1;
newrow["ROWNO"] = rowno;
newrow["COLUMNS NAMES"] = columnno;
dtfail.Rows.Add(newrow);
ds.Tables[0].Rows[i]["Error Message"] = errormsg;
}
}
if (dtfail.Rows.Count > 0)
{
Session["dt_fail"] = dtfail;
Session["ds_data"] = ds;
Delete_Excel_File();
//LinkButton lnk_Import_process = (LinkButton)RadPanelBar1.FindItemByValue("AddAttachment").FindControl("lnk_Import_process");
Telerik.Web.UI.RadWindow newwindow = new Telerik.Web.UI.RadWindow();
// RWM_POSTREPLY.Windows.Remove(newwindow);
newwindow.ID = "RadWindow_import";
newwindow.NavigateUrl = "~/Payroll/frm_AttendanceImportProcess.aspx";
newwindow.Title = "Import Process";
newwindow.Width = 1150;
newwindow.Height = 580;
newwindow.VisibleOnPageLoad = true;
if (RWM_MASTERS.Windows.Count > 1)
{
RWM_MASTERS.Windows.RemoveAt(1);
}
RWM_MASTERS.Windows.Add(newwindow);
RWM_MASTERS.Visible = true;
return;
}
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
_obj_Smhr_Masters = new SMHR_MASTERS();
_obj_Smhr_Masters.MASTER_TYPE = control.ToUpper();
_obj_Smhr_Masters.MASTER_CODE = ds.Tables[0].Rows[i]["Name*"].ToString().Trim();
_obj_Smhr_Masters.MASTER_DESC = ds.Tables[0].Rows[i]["Description"].ToString().Trim();
_obj_Smhr_Masters.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"].ToString());
_obj_Smhr_Masters.ISDELETED = false;
_obj_Smhr_Masters.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Masters.CREATEDDATE = DateTime.Now;
_obj_Smhr_Masters.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Masters.LASTMDFDATE = DateTime.Now;
_obj_Smhr_Masters.OPERATION = operation.Insert;
if (BLL.set_Master(_obj_Smhr_Masters))
{
BLL.ShowMessage(this, " Successfully processed Excel file.");
}
}
rm_MR_Page.SelectedIndex = 0;
LoadGrid();
RG_Master.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Master", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void RadToolBar1_ButtonClick(object sender, Telerik.Web.UI.RadToolBarEventArgs e)
{
if (e.Item.Value == "ExternalStatus")
{
string selectedmasterSets = "";
foreach (GridDataItem item in RadGrid1.SelectedItems)
{
string s = item["MasterCopySeparationSet"].Text.ToString();
int n = 0;
Int32.TryParse(s, out n);
if (n > 0)
{
if (selectedmasterSets != "")
{
selectedmasterSets += ",";
}
selectedmasterSets += s;
}
}
if (selectedmasterSets != "")
{
Telerik.Web.UI.RadWindow mywindow = GetRadWindow("radWindowExternalStatus");
mywindow.Title = Global.rm.GetString("txtSetExternalStatus");
mywindow.NavigateUrl = "SetExternalStatus.aspx?MasterCopySeparationSetList=" + selectedmasterSets;
mywindow.VisibleOnPageLoad = true;;
}
}
/* if (e.Item.Value == "Reimage")
* {
* CCDBaccess db = new CCDBaccess();
*
* string errmsg = "";
* foreach (DataGridItem dataItem in DataGrid1.Items)
* {
* CheckBox cb = (CheckBox)dataItem.Cells[0].Controls[1];
* if (cb.Checked)
* {
* if ((bool)Session["SelectedAllSeps"] == false)
* {
* try
* {
* // All page colors
* TableCell cell = dataItem.Cells[(int)ViewState["MasterSetColumn"]];
* db.ReimageFlatSeparation(Int32.Parse(cell.Text), -1, "", out errmsg);
* }
* catch
* { }
* }
* else
* {
* try
* {
* // Specific color separation
* TableCell cell = dataItem.Cells[(int)ViewState["MasterSetColumn"]];
* TableCell cell2 = dataItem.Cells[(int)ViewState["ColorColumn"]];
* db.ReimageFlatSeparation(Int32.Parse(cell.Text), -1, cell2.Text, out errmsg);
* }
* catch
* { }
* }
* }
* }
*
*
* }
* // if (e.Item.Value == "Refresh" || e.Item.Value == "HideFinished" || e.Item.Value == "Separations")
* // {
* ReBind();
* //}
*/
ReBind();
}
protected void btn_Import_Click(object sender, EventArgs e)
{
try
{
string strcon = null;
string errormsg = "";
string filename = fupld_Position.FileName;
filedatetime = Convert.ToString(DateTime.Now.TimeOfDay) + "_" + filename;
filedatetime = filedatetime.Replace("/", "").Replace(":", ".");
if (fupld_Position.HasFile)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == false)
{
System.IO.Directory.CreateDirectory(Server.MapPath("~/IMPORT_EXCEL/"));
}
fupld_Position.PostedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/IMPORT_EXCEL/"), filedatetime));
string filename1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(filedatetime));
FileInfo fileInfo = new FileInfo(filename1);
if (fileInfo.Exists)
{
string path = MapPath(filename);
string ext = Path.GetExtension(path);
string type = string.Empty;
// set known types based on file extension
if (ext != null)
{
switch (ext.ToLower())
{
case ".xls": type = "excel";
break;
case ".xlsx": type = "excel";
break;
default: type = string.Empty;
break;
}
}
if (type == string.Empty)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == true)
{
string path1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(filedatetime));
System.IO.File.Delete(path1);
}
BLL.ShowMessage(this, "Please select the Excel File (Eg: Excel.xlsx). ");
return;
}
}
}
else
{
BLL.ShowMessage(this, "Please Select the File to be uploaded");
return;
}
string strpath = Server.MapPath("~/IMPORT_EXCEL/");
strpath = strpath + filedatetime;
// Getting data from excell file to dataset.
strcon = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source='" + strpath + "';" + "Extended Properties=Excel 12.0;";
OleDbConnection objConn = null;
objConn = new OleDbConnection(strcon);
objConn.Open();
DataTable dt_check = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string sheetname;
if (dt_check == null)
{
objConn.Close();
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
else
{
sheetname = Convert.ToString(dt_check.Rows[0]["TABLE_NAME"]);
}
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + sheetname + "]", strcon);
da.Fill(ds);
ds.Tables[0].Columns.Add("Error Message");
objConn.Close();
DataTable dt = new DataTable();
DataTable dtfail = new DataTable();
string projecttype = null;
Int32 rowno = 0;
string columnno = null;
//Boolean filestatus = true;
dtfail.Columns.Add("S.NO", typeof(Int32));
dtfail.Columns.Add("ROWNO", typeof(Int32));
dtfail.Columns.Add("COLUMNS NAME", typeof(string));
//For Checking The Position Name Field Is There or not in the excel sheet
if (!(ds.Tables[0].Columns[0].ToString().Trim() == "Name *"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
//For Checking The Position Description Field Is There or not in the excel sheet
if (!(ds.Tables[0].Columns[1].ToString().Trim() == "Description"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
//For Checking The Availability of Job Field
if (!(ds.Tables[0].Columns[2].ToString() == "Job *"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
//For Checking The Availability of Status
if (!(ds.Tables[0].Columns[3].ToString() == "Status *"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
//For Checking The Availability of Start Date
if (!(ds.Tables[0].Columns[4].ToString() == "Start Date *(DD/MM/YYYY)"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
//For Checking The Availability of End Date
if (!(ds.Tables[0].Columns[5].ToString() == "End Date (DD/MM/YYYY)"))
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
//For Checking The Availability of the Records In The Excel Sheet
if (ds.Tables[0].Rows.Count == 0)
{
BLL.ShowMessage(this, "Imported Successfully But There is No Record Available!");
Delete_Excel_File();
return;
}
else
{
bool IsCorrect = true;
bool found = false;
int jobid = 0;
SMHR_POSITIONS _obj_Smhr_Positions = new SMHR_POSITIONS();
loadDropdown();
//For Validating The Excel Sheet
for (int rowindex = 0; rowindex < ds.Tables[0].Rows.Count; rowindex++)
{
if (Convert.ToString(ds.Tables[0].Rows[rowindex][0]) != string.Empty)
{
_obj_Smhr_Positions.OPERATION = operation.Check;
_obj_Smhr_Positions.POSITIONS_CODE = Convert.ToString(ds.Tables[0].Rows[rowindex][0]);
_obj_Smhr_Positions.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
if (Convert.ToString(BLL.get_Positions(_obj_Smhr_Positions).Rows[0]["Count"]) == "1")
{
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "Name *";
errormsg = "Position Name Is Already Exists ";
}
}
if (Convert.ToString(ds.Tables[0].Rows[rowindex][2]) != string.Empty)
{
for (int count = 0; count < rcmb_PositionsJobs.Items.Count; count++)
{
if (Convert.ToString(ds.Tables[0].Rows[rowindex][2]) == rcmb_PositionsJobs.Items[count].Text)
{
found = true;
jobid = Convert.ToInt32(rcmb_PositionsJobs.Items[count].Value);
}
}
if (!found)
{
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "Job";
if (errormsg != string.Empty)
{
errormsg = errormsg + "," + "Job Which You Have Entered Is Not Exists ";
}
else
{
errormsg = "Job Which You Have Entered Is Not Exists ";
}
}
}
if (Convert.ToString(ds.Tables[0].Rows[rowindex][3]) == string.Empty)
{
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "Status *";
if (errormsg != string.Empty)
{
errormsg = errormsg + "," + "Job Status Should Be Active Or In Active ";
}
else
{
errormsg = "Job Status Should Be Active Or In Active ";
}
}
else
{
if (!((Convert.ToString(ds.Tables[0].Rows[rowindex][3]).ToUpper() == "ACTIVE") || (Convert.ToString(ds.Tables[0].Rows[rowindex][3]).ToUpper() == "INACTIVE")))
{
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "Status *";
if (errormsg != string.Empty)
{
errormsg = errormsg + "," + "Job Status Should Be Active Or In Active ";
}
else
{
errormsg = "Job Status Should Be Active Or In Active ";
}
}
}
if ((Convert.ToString(ds.Tables[0].Rows[rowindex][4]) != string.Empty))
{
if (!(BLL.CheckDateFormat(Convert.ToString(ds.Tables[0].Rows[rowindex][4].ToString()))))
{
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "Start Date *(DD/MM/YYYY)";
errormsg = errormsg + "," + "Enter Start Date In The Correct Format ";
}
}
else
{
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "Start Date *(DD/MM/YYYY)";
errormsg = errormsg + "," + "Enter Start Date ";
}
if ((Convert.ToString(ds.Tables[0].Rows[rowindex][4]) != string.Empty) && (Convert.ToString(ds.Tables[0].Rows[rowindex][5]) != string.Empty))
{
bool stdatetime = true;
if (!(BLL.CheckDateFormat(Convert.ToString(ds.Tables[0].Rows[rowindex]["Start Date *(DD/MM/YYYY)"]))))
{
stdatetime = false;
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "Start Date *(DD/MM/YYYY)";
errormsg = errormsg + "," + "Enter Correct Date Format For Start Date ";
// break;
}
if (!(BLL.CheckDateFormat(Convert.ToString(ds.Tables[0].Rows[rowindex]["End Date (DD/MM/YYYY)"]))))
{
stdatetime = false;
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "End Date (DD/MM/YYYY)";
errormsg = errormsg + "," + "Enter Correct Date Format For End Date ";
//break;
}
if (!stdatetime)
{
if (!(Convert.ToDateTime(ds.Tables[0].Rows[rowindex][4].ToString()) > (Convert.ToDateTime(ds.Tables[0].Rows[rowindex][5].ToString()))))
{
IsCorrect = false;
rowno = rowindex + 2;
columnno = columnno + "," + "End Date (DD/MM/YYYY)";
columnno = columnno + "," + "Start Date *(DD/MM/YYYY)";
errormsg = errormsg + "," + "Start Date Should Be Greater Than End Date ";
}
}
}
if (!IsCorrect)
{
DataRow newrow = dtfail.NewRow();
newrow["S.NO"] = dtfail.Rows.Count + 1;
newrow["ROWNO"] = rowno;
newrow["COLUMNS NAME"] = columnno;
dtfail.Rows.Add(newrow);
ds.Tables[0].Rows[rowindex]["Error Message"] = errormsg;
}
// For checking The Duplicate Row in Excel
for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
{
if (ds.Tables[0].Rows[rowindex]["Name *"].ToString().Trim() == ds.Tables[0].Rows[k]["Name *"].ToString().Trim())
{
if (rowindex != k)
{
errormsg = errormsg + "," + " Position Name is repeated in Excel Sheet";
IsCorrect = false;
rowno = rowindex + 2;
columnno = "Name *";
}
}
}
}
if (dtfail.Rows.Count > 0)
{
Session["dt_fail"] = dtfail;
Session["ds_data"] = ds;
Delete_Excel_File();
Telerik.Web.UI.RadWindow newwindow = new Telerik.Web.UI.RadWindow();
newwindow.ID = "RadWindow_import";
newwindow.NavigateUrl = "~/Masters/Importresult.aspx";
newwindow.Title = "Import Job Process";
newwindow.Width = 1150;
newwindow.Height = 580;
newwindow.VisibleOnPageLoad = true;
if (RWM_POSITIONPOSTREPLY.Windows.Count > 1)
{
RWM_POSITIONPOSTREPLY.Windows.RemoveAt(1);
}
RWM_POSITIONPOSTREPLY.Windows.Add(newwindow);
RWM_POSITIONPOSTREPLY.Visible = true;
return;
}
else
{
// For Dumping Each Record In To The Database
for (int xlrows = 0; xlrows < ds.Tables[0].Rows.Count; xlrows++)
{
_obj_Smhr_Positions.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Positions.POSITIONS_CODE = Convert.ToString(ds.Tables[0].Rows[xlrows][0]);
_obj_Smhr_Positions.POSITIONS_DESC = Convert.ToString(ds.Tables[0].Rows[xlrows][1]);
if (Convert.ToString(ds.Tables[0].Rows[xlrows][2]) != string.Empty)
{
for (int count = 0; count < rcmb_PositionsJobs.Items.Count; count++)
{
if (Convert.ToString(ds.Tables[0].Rows[xlrows][2]) == rcmb_PositionsJobs.Items[count].Text)
{
_obj_Smhr_Positions.POSITIONS_ID = Convert.ToInt32(rcmb_PositionsJobs.Items[count].Value);
break;
}
}
}
if (Convert.ToString(ds.Tables[0].Rows[xlrows][2]) != string.Empty)
{
_obj_Smhr_Positions.POSITIONS_JOBSID = jobid;
}
if (Convert.ToString(ds.Tables[0].Rows[xlrows][3]) != string.Empty)
{
if (Convert.ToString(ds.Tables[0].Rows[xlrows][3]).ToUpper() == "ACTIVE")
{
_obj_Smhr_Positions.POSITIONS_STATUS = 0;
}
else
{
_obj_Smhr_Positions.POSITIONS_STATUS = 1;
}
}
string sdate = "";
string edate = "";
sdate = ds.Tables[0].Rows[xlrows][4].ToString();
edate = ds.Tables[0].Rows[xlrows][5].ToString();
bool wrongsdformat = sdate.Contains(".");
bool wrongedformat = edate.Contains(".");
if (wrongsdformat)
{
sdate = sdate.Replace(".", "/");
}
if (wrongedformat)
{
edate = edate.Replace(".", "/");
}
_obj_Smhr_Positions.SDATE = sdate;
_obj_Smhr_Positions.EDATE = edate;
_obj_Smhr_Positions.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Positions.CREATEDDATE = DateTime.Now;
_obj_Smhr_Positions.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_Smhr_Positions.LASTMDFDATE = DateTime.Now;
_obj_Smhr_Positions.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Positions.OPERATION = operation.Check;
_obj_Smhr_Positions.POSITIONS_CODE = Convert.ToString(ds.Tables[0].Rows[xlrows][0]);
_obj_Smhr_Positions.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
if (Convert.ToString(BLL.get_Positions(_obj_Smhr_Positions).Rows[0]["Count"]) == "1")
{
continue;
//IsCorrect = true;
}
else
{
_obj_Smhr_Positions.OPERATION = operation.Insert1;
if (BLL.set_Positions(_obj_Smhr_Positions))
{
IsCorrect = true;
}
}
}
Rm_PO_page.SelectedIndex = 0;
LoadGrid();
Rm_PO_page.DataBind();
if (IsCorrect)
{
BLL.ShowMessage(this, "Information Uploaded SuccessFully");
}
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frmposition.aspx", ex.StackTrace, DateTime.Now);
Response.Redirect("Frm_ErrorPage.aspx");
}
}
protected void Btn_upload_Click(object sender, EventArgs e)
{
try
{
_obj_vamt.OPERATION = operation.Select;
_obj_vamt.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
if ((rcmb_Businessunit.SelectedIndex > 0) && (rcmb_Financialperiod.SelectedIndex > 0))
{
_obj_vamt.BUID = Convert.ToInt32(rcmb_Businessunit.SelectedValue);
dt_Result = BLL.get_Employeevariableamt(_obj_vamt);//GETTING ALL EMPLOYEES WHO ARE HAVING VARIABLE PAY
}
_obj_vamt.OPERATION = operation.Check;
_obj_vamt.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
dt_resultcomp = BLL.Get_Components(_obj_vamt);
string strcon = null;
string strfilename1 = FileUpload1.FileName;
strfilename2 = Convert.ToString(DateTime.Now.TimeOfDay) + "_" + strfilename1;
strfilename2 = strfilename2.Replace("/", "").Replace(":", ".");
if (FileUpload1.HasFile)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == false)
{
System.IO.Directory.CreateDirectory(Server.MapPath("~/IMPORT_EXCEL/"));
}
FileUpload1.PostedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/IMPORT_EXCEL/"), strfilename2));
string filename1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
FileInfo fileInfo = new FileInfo(filename1);
if (fileInfo.Exists)
{
string path = MapPath(strfilename1);
// string name = Path.GetFileName( path );
string ext = Path.GetExtension(path);
string type = string.Empty;
if (ext != null)
{
switch (ext.ToLower())
{
case ".xls":
type = "excel";
break;
case ".xlsx":
type = "excel";
break;
default:
type = string.Empty;
break;
}
}
if (type == string.Empty)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == true)
{
string path1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
System.IO.File.Delete(path1);
}
BLL.ShowMessage(this, "Please select the Excel File (Eg: Excel.xlsx). ");
return;
}
}
}
else
{
BLL.ShowMessage(this, "Please Select the File to be uploaded");
return;
}
string strpath = Server.MapPath("~/IMPORT_EXCEL/");
strpath = strpath + strfilename2;
// Getting data from excell file to dataset.
strcon = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source='" + strpath + "';" + "Extended Properties=Excel 12.0;";
OleDbConnection objConn = null;
objConn = new OleDbConnection(strcon);
objConn.Open();
DataTable dt_chk2 = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string sheetname;
if (dt_chk2 == null)
{
objConn.Close();
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
else
{
sheetname = Convert.ToString(dt_chk2.Rows[0]["TABLE_NAME"]);
}
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + sheetname + "]", strcon);
da.Fill(ds);
ds.Tables[0].Columns.Add("Error Message");
objConn.Close();
DataTable dt = new DataTable();
DataTable dtfail = new DataTable();
string errormsg = string.Empty;
//string projecttype = null;
Int32 rowno = 0;
//DateTime dat;
string columnno = null;
//string projname = null;
Boolean filestatus = true;
Boolean filestatus1 = true;
dtfail.Columns.Add("S.NO", typeof(Int32));
dtfail.Columns.Add("ROWNO", typeof(Int32));
dtfail.Columns.Add("COLUMNS NAMES", typeof(string));
if (ds.Tables[0].Columns[0].ToString().Trim() == "EmployeeId*")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[1].ToString().Trim() == "VariablePayComponent*")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[2].ToString().Trim() == "Percentage*")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Rows.Count == 0)
{
Delete_Excel_File();
BLL.ShowMessage(this, "Successfully processed Excel file. No Records are Imported.");
return;
}
DataTable dt_empexist = new DataTable();
DataTable dt_empid = new DataTable();
DataTable dt_failm = new DataTable();
dt_failm.Columns.Add("S.NO", typeof(Int32));
dt_failm.Columns.Add("ROWNO", typeof(Int32));
dt_failm.Columns.Add("COLUMNS NAMES", typeof(string));
DataColumn dc = new DataColumn();
//dc.ColumnName = "Component";
//dc.DataType = typeof(string);
//dt_empexist.Columns.Add(dc);
DataColumn dce0 = new DataColumn();
dce0.ColumnName = "EmpId";
dce0.DataType = typeof(string);
dt_empid.Columns.Add(dce0);
DataColumn dc1 = new DataColumn();
dc1.ColumnName = "Percentage";
dc1.DataType = typeof(double);
dt_empexist.Columns.Add(dc1);
DataColumn dc2 = new DataColumn();
dc2.ColumnName = "Empcode";
dc2.DataType = typeof(string);
dt_empexist.Columns.Add(dc2);
//@@@@@@@@@@@@@@@@@@
DataTable dt_empexist1 = new DataTable();
DataColumn dcl2 = new DataColumn();
dcl2.ColumnName = "Empcode";
dcl2.DataType = typeof(string);
dt_empexist1.Columns.Add(dcl2);
DataColumn dcl1 = new DataColumn();
dcl1.ColumnName = "Percentage";
dcl1.DataType = typeof(double);
dt_empexist1.Columns.Add(dcl1);
DataColumn dcl3 = new DataColumn();
dcl3.ColumnName = "ErrorMessage";
dcl3.DataType = typeof(string);
dt_empexist1.Columns.Add(dcl3);
bool varempcomp = false;
for (int v = 0; v < ds.Tables[0].Rows.Count; v++)
{
for (int m = 0; m < ds.Tables[0].Rows.Count; m++)
{
if ((ds.Tables[0].Rows[v]["EmployeeId*"].ToString().Trim() == ds.Tables[0].Rows[m]["EmployeeId*"].ToString().Trim()) && (ds.Tables[0].Rows[v]["VariablePayComponent*"].ToString().Trim() == ds.Tables[0].Rows[m]["VariablePayComponent*"].ToString().Trim()))
{
if (v != m)
{
varempcomp = true;
errormsg = "VariablePayComponent does not exist";
filestatus = false;
rowno = v + 2;
columnno = "VariablePayComponent*";
DataRow newrow = dtfail.NewRow();
newrow["S.NO"] = dtfail.Rows.Count + 1;
newrow["ROWNO"] = rowno;
newrow["COLUMNS NAMES"] = columnno;
dtfail.Rows.Add(newrow);
ds.Tables[0].Rows[v]["Error Message"] = errormsg;
}
}
}
}
if (!(varempcomp))
{
for (int p = 0; p < ds.Tables[0].Rows.Count; p++)
{
bool found1 = false;
int x = 0;
int per = 0;
DataRow dr = dt_empexist.NewRow();
string EMP_CODE1 = string.Empty;
// dr[0] = empcomponent;
if (ds.Tables[0].Rows[p]["EmployeeId*"].ToString().Trim() != "")
{
EMP_CODE1 = ds.Tables[0].Rows[p]["EmployeeId*"].ToString().Trim();
x = Convert.ToInt32(ds.Tables[0].Rows[p]["Percentage*"]);
}
for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
{
if (ds.Tables[0].Rows[p]["EmployeeId*"].ToString().Trim() == ds.Tables[0].Rows[k]["EmployeeId*"].ToString().Trim())
{
if (p != k)
{
int y = Convert.ToInt32(ds.Tables[0].Rows[k]["Percentage*"]);
per = per + y;
}
}
}
x = x + per;
// compare the existance code which was recorded
for (int rowsrepeated = 0; rowsrepeated < dt_empexist.Rows.Count; rowsrepeated++)
{
if (dt_empexist.Rows[rowsrepeated][1].ToString() == EMP_CODE1)
{
found1 = true;
break;
}
}
if (found1 == false)
{
dr[0] = x;
// x = x + percentage1;
dr[1] = EMP_CODE1;
dt_empexist.Rows.Add(dr);
}
}
for (int b = 0; b < dt_empexist.Rows.Count; b++)
{
errormsg = string.Empty;
DataRow dr = dt_empexist1.NewRow();
if (Convert.ToInt32(dt_empexist.Rows[b]["Percentage"]) != 100)
{
filestatus = false;
errormsg = "Total Variable Componentpercentage should be 100 for this employee";
dr[0] = dt_empexist.Rows[b]["Empcode"].ToString().Trim();
dr[1] = Convert.ToInt32(dt_empexist.Rows[b]["Percentage"]);
dr[2] = errormsg;
dt_empexist1.Rows.Add(dr);
}
}
for (int msg = 0; msg < dt_empexist1.Rows.Count; msg++)
{
for (int g = 0; g < ds.Tables[0].Rows.Count; g++)
{
if (dt_empexist1.Rows[msg]["Empcode"].ToString() == ds.Tables[0].Rows[g]["EmployeeId*"].ToString())
{
errormsg = "Employee Does Not exist";
filestatus1 = false;
rowno = g + 2;
columnno = "EmployeeId*";
}
if (filestatus1 == false)
{
DataRow newrow = dt_failm.NewRow();
newrow["S.NO"] = dt_failm.Rows.Count + 1;
newrow["ROWNO"] = rowno;
newrow["COLUMNS NAMES"] = columnno;
dt_failm.Rows.Add(newrow);
// ds.Tables[0].Rows[i]["Error Message"] = errormsg;
}
filestatus1 = true;
}
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
bool found = false;
errormsg = string.Empty;
columnno = string.Empty;
//int count = 0;
bool EMPCODE_EXISTS = false;
if (ds.Tables[0].Rows[i]["EmployeeId*"].ToString().Trim() != "")
{
// for looping the empcode for checking of the existence of the employee for that businessunit
string EMP_CODE = ds.Tables[0].Rows[i]["EmployeeId*"].ToString().Trim();
for (int Rows = 0; Rows < dt_Result.Rows.Count; Rows++)
{
// for checking employee existance whether exel employee is having variable pay or not
string EMP_ID = dt_Result.Rows[Rows]["EMP_NAME"].ToString();
int CUT = EMP_ID.LastIndexOf("-");
string EMP_CODES = EMP_ID.Substring(0, CUT);
if (EMP_CODES == EMP_CODE)
{
// int x = 0;
EMPCODE_EXISTS = true;
}
}
if (!(EMPCODE_EXISTS))
{
errormsg = "Employee Does Not exist";
filestatus = false;
rowno = i + 2;
columnno = "EmployeeId*";
}
}
else
{
errormsg = "Enter EmployeeId";
filestatus = false;
rowno = i + 2;
columnno = "EmployeeId*";
}
if (ds.Tables[0].Rows[i]["VariablePayComponent*"].ToString().Trim() != "")
{
bool varpaycomp1 = false;
string empcomponent = ds.Tables[0].Rows[i]["VariablePayComponent*"].ToString().Trim();
for (int k = 0; k < dt_resultcomp.Rows.Count; k++)
{
if (empcomponent == dt_resultcomp.Rows[k]["SMHR_VPCOMP_COMPNAME"].ToString())
{
varpaycomp1 = true;
}
}
if (varpaycomp1 == false)
{
errormsg = errormsg + "," + "VariablePayComponent does not exist";
filestatus = false;
rowno = i + 2;
columnno = "VariablePayComponent*";
}
}
else
{
errormsg = errormsg + "," + "Enter VariablePayComponent ";
filestatus = false;
rowno = i + 2;
columnno = "VariablePayComponent*";
}
if (ds.Tables[0].Rows[i]["Percentage*"].ToString().Trim() != "")
{
int VPMIN = 0;
int VPMAX = 0;
int SMVPCOMP_ID = 0;
bool varpaycomp = false;
string empcomponent1 = ds.Tables[0].Rows[i]["VariablePayComponent*"].ToString().Trim();
int percentage1 = Convert.ToInt32(ds.Tables[0].Rows[i]["Percentage*"].ToString().Trim());
for (int k = 0; k < dt_resultcomp.Rows.Count; k++)
{
if (empcomponent1 == dt_resultcomp.Rows[k]["SMHR_VPCOMP_COMPNAME"].ToString())
{
SMVPCOMP_ID = Convert.ToInt32(dt_resultcomp.Rows[k]["SMHR_VPCOMP_ID"]);
VPMIN = Convert.ToInt32(dt_resultcomp.Rows[k]["SMHR_VPCOMP_MIN"]);
VPMAX = Convert.ToInt32(dt_resultcomp.Rows[k]["SMHR_VPCOMP_MAX"]);
varpaycomp = true;
}
}
if (!((percentage1 >= VPMIN) && (percentage1 <= VPMAX)))
{
// string min = dt_resultcomp.Rows[exlrows]["SMHR_VPCOMP_MIN"].ToString();
//string max = dt_resultcomp.Rows[exlrows]["SMHR_VPCOMP_MAX"].ToString();
errormsg = errormsg + "," + "Percentage you have entered for variable component is out of range:" + "It Should be in Between(" + VPMIN + "," + VPMAX + ")";
filestatus = false;
rowno = i + 2;
columnno = "Percentage*";
}
}
else
{
errormsg = errormsg + "," + "Enter Percentage ";
filestatus = false;
rowno = i + 2;
columnno = "Percentage*";
}
if (filestatus == false)
{
DataRow newrow = dtfail.NewRow();
newrow["S.NO"] = dtfail.Rows.Count + 1;
newrow["ROWNO"] = rowno;
newrow["COLUMNS NAMES"] = columnno;
dtfail.Rows.Add(newrow);
ds.Tables[0].Rows[i]["Error Message"] = errormsg;
}
}
}
if (dtfail.Rows.Count > 0)
{
if (dtfail.Rows[0]["COLUMNS NAMES"].ToString() != string.Empty)
{
//for (int d = 0; d < dtfail.Rows.Count; d++)
//{
// for (int c = 0; c < dt_empexist1.Rows.Count; c++)
// {
// if (ds.Tables[0].Rows[d]["EmployeeId*"].ToString().Trim() == dt_empexist1.Rows[c]["Empcode"].ToString().Trim())
// {
// ds.Tables[0].Rows[d]["Error Message"] = ds.Tables[0].Rows[d]["Error Message"].ToString() + "," + dt_empexist1.Rows[c]["ErrorMessage"].ToString();
// // dtfail.Rows[d]["COLUMNS NAMES"] = dt_failm.Rows[d]["COLUMNS NAMES"].ToString() + dt_failm.Rows[c]["COLUMNS NAMES"].ToString();
// }
// }
//}
Session["dt_fail"] = dtfail;
Session["ds_data"] = ds;
Delete_Excel_File();
//LinkButton lnk_Import_process = (LinkButton)RadPanelBar1.FindItemByValue("AddAttachment").FindControl("lnk_Import_process");
Telerik.Web.UI.RadWindow newwindow = new Telerik.Web.UI.RadWindow();
// RWM_POSTREPLY.Windows.Remove(newwindow);
newwindow.ID = "RadWindow_import";
newwindow.NavigateUrl = "~/Payroll/frm_AttendanceImportProcess.aspx";
newwindow.Title = "Import Process";
newwindow.Width = 1150;
newwindow.Height = 580;
newwindow.VisibleOnPageLoad = true;
if (RWM_POSTREPLY1.Windows.Count > 1)
{
RWM_POSTREPLY1.Windows.RemoveAt(1);
}
RWM_POSTREPLY1.Windows.Add(newwindow);
RWM_POSTREPLY1.Visible = true;
return;
}
else if (dtfail.Rows[0]["COLUMNS NAMES"].ToString() == string.Empty)
{
for (int d = 0; d < dtfail.Rows.Count; d++)
{
for (int c = 0; c < dt_empexist1.Rows.Count; c++)
{
if (ds.Tables[0].Rows[d]["EmployeeId*"].ToString().Trim() == dt_empexist1.Rows[c]["Empcode"].ToString().Trim())
{
ds.Tables[0].Rows[d]["Error Message"] = ds.Tables[0].Rows[d]["Error Message"].ToString() + "," + dt_empexist1.Rows[c]["ErrorMessage"].ToString();
// dtfail.Rows[d]["COLUMNS NAMES"] = dt_failm.Rows[d]["COLUMNS NAMES"].ToString() + dt_failm.Rows[c]["COLUMNS NAMES"].ToString();
}
}
}
Session["dt_fail"] = dt_failm;
Session["ds_data"] = ds;
Delete_Excel_File();
//LinkButton lnk_Import_process = (LinkButton)RadPanelBar1.FindItemByValue("AddAttachment").FindControl("lnk_Import_process");
Telerik.Web.UI.RadWindow newwindow = new Telerik.Web.UI.RadWindow();
// RWM_POSTREPLY.Windows.Remove(newwindow);
newwindow.ID = "RadWindow_import";
newwindow.NavigateUrl = "~/Payroll/frm_AttendanceImportProcess.aspx";
newwindow.Title = "Import Process";
newwindow.Width = 1150;
newwindow.Height = 580;
newwindow.VisibleOnPageLoad = true;
if (RWM_POSTREPLY1.Windows.Count > 1)
{
RWM_POSTREPLY1.Windows.RemoveAt(1);
}
RWM_POSTREPLY1.Windows.Add(newwindow);
RWM_POSTREPLY1.Visible = true;
return;
}
}
else
{
int emp_ID1 = 0;
bool exists = false;
bool status = false;
bool et = false;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
SMHR_EMPLOYEE1 _obj_SMHR_EMPLOYEE1 = new SMHR_EMPLOYEE1();
_obj_SMHR_EMPLOYEE1.MODE = 8;
_obj_SMHR_EMPLOYEE1.EMP_ID = ds.Tables[0].Rows[i]["EmployeeId*"].ToString().Trim();
_obj_SMHR_EMPLOYEE1.ORGID = Convert.ToInt32(Session["ORG_ID"]);
DataTable dtempid22 = Pms_Bll.get_Employee1(_obj_SMHR_EMPLOYEE1);
if (dtempid22.Rows.Count != 0)
{
emp_ID1 = Convert.ToInt32(dtempid22.Rows[0]["emp_id"]);
}
_obj_vamt.EMP_ID = emp_ID1;
_obj_vamt.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_vamt.BUID = Convert.ToInt32(rcmb_Businessunit.SelectedValue);
_obj_vamt.financial_period = Convert.ToInt32(rcmb_Financialperiod.SelectedValue);
_obj_vamt.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_vamt.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
string name = ds.Tables[0].Rows[i]["VariablePayComponent*"].ToString();
for (int comp = 0; comp < dt_resultcomp.Rows.Count; comp++)
{
if (name == dt_resultcomp.Rows[comp]["SMHR_VPCOMP_COMPNAME"].ToString())
{
_obj_vamt.component_id = Convert.ToInt32(dt_resultcomp.Rows[comp]["SMHR_VPCOMP_ID"].ToString());
}
}
for (int empid = 0; empid < dt_empid.Rows.Count; empid++)
{
if (emp_ID1 == Convert.ToInt32(dt_empid.Rows[empid][0].ToString()))
{
exists = true;
}
}
_obj_vamt.component_percentage = Convert.ToInt32(ds.Tables[0].Rows[i]["Percentage*"]);
if (!exists)
{
_obj_vamt.OPERATION = operation.Delete;
et = BLL.set_Component(_obj_vamt);
}
//_obj_vamt.OPERATION = operation.Insert;
_obj_vamt.OPERATION = operation.MODE1;
status = BLL.set_Component(_obj_vamt);
//DataRow dr = dt_empid.NewRow();
//dr[0] = emp_ID1;
//dt_empid.Rows.Add(dr);
}
if (status == true)
{
BLL.ShowMessage(this, "Employee Components Set for the Selected Employees");
}
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_ImportEmpcomponents", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
try
{
string strcon = null;
string strfilename1 = FileUpload1.FileName;
strfilename2 = Convert.ToString(DateTime.Now.TimeOfDay) + "_" + strfilename1;
strfilename2 = strfilename2.Replace("/", "").Replace(":", ".");
if (FileUpload1.HasFile)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == false)
{
System.IO.Directory.CreateDirectory(Server.MapPath("~/IMPORT_EXCEL/"));
}
FileUpload1.PostedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/IMPORT_EXCEL/"), strfilename2));
string filename1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
FileInfo fileInfo = new FileInfo(filename1);
if (fileInfo.Exists)
{
string path = MapPath(strfilename1);
// string name = Path.GetFileName( path );
string ext = Path.GetExtension(path);
string type = string.Empty;
if (ext != null)
{
switch (ext.ToLower())
{
case ".xls":
type = "excel";
break;
case ".xlsx":
type = "excel";
break;
default:
type = string.Empty;
break;
}
}
if (type == string.Empty)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == true)
{
string path1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
System.IO.File.Delete(path1);
}
BLL.ShowMessage(this, "Please select the Excel File (Eg: Excel.xlsx). ");
return;
}
}
}
else
{
BLL.ShowMessage(this, "Please Select the File to be uploaded");
return;
}
string strpath = Server.MapPath("~/IMPORT_EXCEL/");
strpath = strpath + strfilename2;
// Getting data from excell file to dataset.
strcon = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source='" + strpath + "';" + "Extended Properties=Excel 12.0;";
OleDbConnection objConn = null;
objConn = new OleDbConnection(strcon);
objConn.Open();
DataTable dt_chk2 = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string sheetname;
if (dt_chk2 == null)
{
objConn.Close();
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
else
{
sheetname = Convert.ToString(dt_chk2.Rows[0]["TABLE_NAME"]);
}
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + sheetname + "]", strcon);
da.Fill(ds);
ds.Tables[0].Columns.Add("Error Message");
objConn.Close();
DataTable dt = new DataTable();
DataTable dtfail = new DataTable();
string errormsg = string.Empty;
string projecttype = null;
Int32 rowno = 0;
DateTime dat;
string columnno = null;
string projname = null;
Boolean filestatus = true;
dtfail.Columns.Add("S.NO", typeof(Int32));
dtfail.Columns.Add("ROWNO", typeof(Int32));
dtfail.Columns.Add("COLUMNS NAMES", typeof(string));
if (ds.Tables[0].Columns[0].ToString().Trim() == "Component Name*")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[1].ToString().Trim() == "Component Description")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[2].ToString().Trim() == "Status")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[3].ToString().Trim() == "Minimum Percentage*")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[4].ToString().Trim() == "Max Percentage*")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Rows.Count == 0)
{
Delete_Excel_File();
BLL.ShowMessage(this, "Successfully processed Excel file. No Records are Imported.");
return;
}
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
errormsg = string.Empty;
columnno = string.Empty;
if (ds.Tables[0].Rows[i]["Component Name*"].ToString().Trim() != "")
{
}
else
{
errormsg = "enter component name";
filestatus = false;
rowno = i + 2;
columnno = "Component Name*";
}
for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
{
if (ds.Tables[0].Rows[i]["Component Name*"].ToString().Trim() == ds.Tables[0].Rows[k]["Component Name*"].ToString().Trim())
{
if (i != k)
{
errormsg = errormsg + "," + "Component Name with this Name is repeated in Excel Sheet";
filestatus = false;
rowno = i + 2;
columnno = "Component Name*";
}
}
}
if (ds.Tables[0].Rows[i]["Minimum Percentage*"].ToString().Trim() != "")
{
if (Convert.ToInt32(ds.Tables[0].Rows[i]["Minimum Percentage*"]) < 1000)
{
}
else
{
errormsg = errormsg + "," + "Minimum Percentage should be three digits only";
filestatus = false;
rowno = i + 2;
columnno = "Minimum Percentage*";
}
}
else
{
errormsg = errormsg + "," + "Enter Minimum Percentage";
filestatus = false;
rowno = i + 2;
columnno = "Minimum Percentage*";
}
for (int p = 0; p < ds.Tables[0].Rows.Count; p++)
{
if (Convert.ToInt32(ds.Tables[0].Rows[i]["Minimum Percentage*"]) < Convert.ToInt32(ds.Tables[0].Rows[p]["Max Percentage*"]))
{
//if (i != p)
//{
// errormsg = errormsg + "," + "Minimum Percentage should be less than Max percentage";
// filestatus = false;
// rowno = i + 2;
// columnno = "Component Name*";
//}
}
else
{
errormsg = errormsg + "," + "Minimum Percentage should be less than Max percentage";
filestatus = false;
rowno = i + 2;
columnno = "Minimum Percentage*";
}
}
if (ds.Tables[0].Rows[i]["Max Percentage*"].ToString().Trim() != "")
{
if (Convert.ToInt32(ds.Tables[0].Rows[i]["Max Percentage*"]) < 1000)
{
}
else
{
errormsg = errormsg + "," + "Max Percentage should be three digits only";
filestatus = false;
rowno = i + 2;
columnno = "Max Percentage*";
}
}
else
{
errormsg = errormsg + "," + "Enter Max Percentage";
filestatus = false;
rowno = i + 2;
columnno = "Max Percentage*";
}
if (filestatus == false)
{
DataRow newrow = dtfail.NewRow();
newrow["S.NO"] = dtfail.Rows.Count + 1;
newrow["ROWNO"] = rowno;
newrow["COLUMNS NAMES"] = columnno;
dtfail.Rows.Add(newrow);
ds.Tables[0].Rows[i]["Error Message"] = errormsg;
}
}
if (dtfail.Rows.Count > 0)
{
Session["dt_fail"] = dtfail;
Session["ds_data"] = ds;
Delete_Excel_File();
//LinkButton lnk_Import_process = (LinkButton)RadPanelBar1.FindItemByValue("AddAttachment").FindControl("lnk_Import_process");
Telerik.Web.UI.RadWindow newwindow = new Telerik.Web.UI.RadWindow();
// RWM_POSTREPLY.Windows.Remove(newwindow);
newwindow.ID = "RadWindow_import";
newwindow.NavigateUrl = "~/Payroll/frm_AttendanceImportProcess.aspx";
newwindow.Title = "Import Process";
newwindow.Width = 1150;
newwindow.Height = 580;
newwindow.VisibleOnPageLoad = true;
if (RWM_POSTREPLY1.Windows.Count > 1)
{
RWM_POSTREPLY1.Windows.RemoveAt(1);
}
RWM_POSTREPLY1.Windows.Add(newwindow);
RWM_POSTREPLY1.Visible = true;
return;
}
else
{
bool status = false;
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
_obj_vpc.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_vpc.component_desc = Convert.ToString(ds.Tables[0].Rows[i]["Component Description"]).Trim();
_obj_vpc.component_name = Convert.ToString(ds.Tables[0].Rows[i]["Component Name*"]).Trim();
_obj_vpc.component_max = Convert.ToInt32(ds.Tables[0].Rows[i]["Max Percentage*"]);
_obj_vpc.component_min = Convert.ToInt32(ds.Tables[0].Rows[i]["Minimum Percentage*"]);
if (ds.Tables[0].Rows[i]["Status"].ToString() == "")
{
_obj_vpc.component_status = false;
}
else
{
_obj_vpc.component_status = Convert.ToBoolean(ds.Tables[0].Rows[i]["Status"]);
}
_obj_vpc.CREATEDBY = Convert.ToInt32(Session["USER_ID"]);
_obj_vpc.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]);
_obj_vpc.OPERATION = operation.Insert;
status = BLL.set_Component(_obj_vpc);
//if (status)
// BLL.ShowMessage(this, "Information Saved Successfully");
//else
// BLL.ShowMessage(this, "Error Occured");
//LoadGrid();
//rg_VariablepayComponents.DataBind();
}
if (status)
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
LoadGrid();
rg_VariablepayComponents.DataBind();
}
}
//
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_VariableComponents", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}
protected void Btn_Imp_Category_click(object sender, EventArgs e)
{
try
{
//written by Rajasekhar
//To Import category Excel Sheet
string strcon = null;
string strfilename1 = FileUpload1.FileName;
strfilename2 = Convert.ToString(DateTime.Now.TimeOfDay) + "_" + strfilename1;
strfilename2 = strfilename2.Replace("/", "").Replace(":", ".");
if (FileUpload1.HasFile)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == false)
{
System.IO.Directory.CreateDirectory(Server.MapPath("~/IMPORT_EXCEL/"));
}
FileUpload1.PostedFile.SaveAs(System.IO.Path.Combine(Server.MapPath("~/IMPORT_EXCEL/"), strfilename2));
string filename1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
FileInfo fileInfo = new FileInfo(filename1);
if (fileInfo.Exists)
{
string path = MapPath(strfilename1);
// string name = Path.GetFileName( path );
string ext = Path.GetExtension(path);
string type = string.Empty;
// set known types based on file extension
if (ext != null)
{
switch (ext.ToLower())
{
case ".xls":
type = "excel";
break;
case ".xlsx":
type = "excel";
break;
default:
type = string.Empty;
break;
}
}
if (type == string.Empty)
{
if (System.IO.Directory.Exists(Server.MapPath("~/IMPORT_EXCEL/")) == true)
{
string path1 = Server.MapPath("~/IMPORT_EXCEL/") + ("") + (Convert.ToString(strfilename2));
System.IO.File.Delete(path1);
}
BLL.ShowMessage(this, "Please select the Excel File (Eg: Excel.xlsx). ");
return;
}
}
}
else
{
BLL.ShowMessage(this, "Please Select the File to be uploaded");
return;
}
string strpath = Server.MapPath("~/IMPORT_EXCEL/");
strpath = strpath + strfilename2;
// Getting data from excell file to dataset.
strcon = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source='" + strpath + "';" + "Extended Properties=Excel 12.0;";
OleDbConnection objConn = null;
objConn = new OleDbConnection(strcon);
objConn.Open();
DataTable dt_chk2 = objConn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
string sheetname;
if (dt_chk2 == null)
{
objConn.Close();
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
else
{
sheetname = Convert.ToString(dt_chk2.Rows[0]["TABLE_NAME"]);
}
OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [" + sheetname + "]", strcon);
da.Fill(ds);
ds.Tables[0].Columns.Add("Error Message");
objConn.Close();
DataTable dt = new DataTable();
DataTable dtfail = new DataTable();
string errormsg = string.Empty;
string projecttype = null;
Int32 rowno = 0;
DateTime dat;
string columnno = null;
string projname = null;
Boolean filestatus = true;
dtfail.Columns.Add("S.NO", typeof(Int32));
dtfail.Columns.Add("ROWNO", typeof(Int32));
dtfail.Columns.Add("COLUMNS NAMES", typeof(string));
if (ds.Tables[0].Columns[0].ToString().Trim() == "Name*")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[1].ToString().Trim() == "Description")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[2].ToString().Trim() == "OverTime Enabled")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[3].ToString().Trim() == "Bank Info")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[4].ToString().Trim() == "Currency")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[5].ToString().Trim() == "Age")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[6].ToString().Trim() == "DateFormat")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[7].ToString().Trim() == "Address")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[8].ToString().Trim() == "Country")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[9].ToString().Trim() == "Fiscal Year")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[10].ToString().Trim() == "Calendar")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[11].ToString().Trim() == "Payment Methods")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Columns[12].ToString().Trim() == "Localisation")
{
}
else
{
Delete_Excel_File();
BLL.ShowMessage(this, "Please select the Correct Excel Template Sheet.");
return;
}
if (ds.Tables[0].Rows.Count == 0)
{
Delete_Excel_File();
BLL.ShowMessage(this, "Successfully processed Excel file. No Records are Imported.");
return;
}
//to check the data in excel
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
errormsg = string.Empty;
columnno = string.Empty;
if (ds.Tables[0].Rows[i]["Name*"].ToString().Trim() != "")
{
_obj_Smhr_Category = new SMHR_CATEGORY();
_obj_Smhr_Category.CATEGORY_CODE = Convert.ToString(ds.Tables[0].Rows[i]["Name*"]).Trim();
_obj_Smhr_Category.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Category.OPERATION = operation.Check;
if (Convert.ToString(BLL.get_Category(_obj_Smhr_Category).Rows[0]["Count"]) != "0")
{
// BLL.ShowMessage(this, "Category with this Name Already Exists");
// return;
errormsg = "Category with this Name Already Exists";
filestatus = false;
rowno = i + 2;
columnno = "Name*";
}
}
else
{
filestatus = false;
rowno = i + 2;
columnno = "Name*";
}
for (int k = 0; k < ds.Tables[0].Rows.Count; k++)
{
if (ds.Tables[0].Rows[i]["Name*"].ToString().Trim() == ds.Tables[0].Rows[k]["Name*"].ToString().Trim())
{
if (i != k)
{
errormsg = "Category with this Name is repeated in Excel Sheet";
filestatus = false;
rowno = i + 2;
columnno = "Name*";
}
}
}
if (ds.Tables[0].Rows[i]["Description"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Description";
}
if (ds.Tables[0].Rows[i]["OverTime Enabled"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "OverTime Enabled";
}
if (ds.Tables[0].Rows[i]["Bank Info"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Bank Info";
}
if (ds.Tables[0].Rows[i]["Currency"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Currency";
}
if (ds.Tables[0].Rows[i]["Age"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Age";
}
if (ds.Tables[0].Rows[i]["DateFormat"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "DateFormat";
}
if (ds.Tables[0].Rows[i]["Address"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Address";
}
if (ds.Tables[0].Rows[i]["Country"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Country";
}
if (ds.Tables[0].Rows[i]["Fiscal Year"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Fiscal Year";
}
if (ds.Tables[0].Rows[i]["Calendar"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Calendar";
}
if (ds.Tables[0].Rows[i]["Payment Methods"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Payment Methods";
}
if (ds.Tables[0].Rows[i]["Localisation"].ToString().Trim() != "")
{
}
else
{
filestatus = false;
rowno = i + 2;
columnno = columnno + "," + "Localisation";
}
if (filestatus == false)
{
DataRow newrow = dtfail.NewRow();
newrow["S.NO"] = dtfail.Rows.Count + 1;
newrow["ROWNO"] = rowno;
newrow["COLUMNS NAMES"] = columnno;
dtfail.Rows.Add(newrow);
ds.Tables[0].Rows[i]["Error Message"] = errormsg;
}
}
if (dtfail.Rows.Count > 0)
{
Session["dt_fail"] = dtfail;
Session["ds_data"] = ds;
Delete_Excel_File();
//LinkButton lnk_Import_process = (LinkButton)RadPanelBar1.FindItemByValue("AddAttachment").FindControl("lnk_Import_process");
Telerik.Web.UI.RadWindow newwindow = new Telerik.Web.UI.RadWindow();
// RWM_POSTREPLY.Windows.Remove(newwindow);
newwindow.ID = "RadWindow_import";
newwindow.NavigateUrl = "~/Payroll/frm_AttendanceImportProcess.aspx";
newwindow.Title = "Import Process";
newwindow.Width = 1150;
newwindow.Height = 580;
newwindow.VisibleOnPageLoad = true;
if (RWM_POSTREPLY1.Windows.Count > 1)
{
RWM_POSTREPLY1.Windows.RemoveAt(1);
}
RWM_POSTREPLY1.Windows.Add(newwindow);
RWM_POSTREPLY1.Visible = true;
return;
}
else
{
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
bool status = false;
_obj_Smhr_Category.CATEGORY_CODE = Convert.ToString(ds.Tables[0].Rows[i]["Name*"]).Trim();
_obj_Smhr_Category.CATEGORY_DESC = Convert.ToString(ds.Tables[0].Rows[i]["Description"]).Trim();
_obj_Smhr_Category.CATEGORY_ISOVERTIME = Convert.ToBoolean(ds.Tables[0].Rows[i]["OverTime Enabled"]);
_obj_Smhr_Category.CATEGORY_NEEDBANKINFO = Convert.ToBoolean(ds.Tables[0].Rows[i]["Bank Info"]);
_obj_Smhr_Category.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Category.CATEGORY_ISFISCALYEAR = Convert.ToBoolean(ds.Tables[0].Rows[i]["Fiscal Year"]);
_obj_Smhr_Category.CATEGORY_ISCURRENCY = Convert.ToBoolean(ds.Tables[0].Rows[i]["Currency"]);
_obj_Smhr_Category.CATEGORY_ISDATEFORMAT = Convert.ToBoolean(ds.Tables[0].Rows[i]["DateFormat"]);
_obj_Smhr_Category.CATEGORY_ISCOUNTRY = Convert.ToBoolean(ds.Tables[0].Rows[i]["Country"]);
_obj_Smhr_Category.CATEGORY_ISADDRESS = Convert.ToBoolean(ds.Tables[0].Rows[i]["Address"]);
_obj_Smhr_Category.CATEGORY_ISAGE = Convert.ToBoolean(ds.Tables[0].Rows[i]["Age"]);
_obj_Smhr_Category.CATEGORY_ISPAYMENTMODE = Convert.ToBoolean(ds.Tables[0].Rows[i]["Payment Methods"]);
_obj_Smhr_Category.CATEGORY_ISCALENDERYEAR = Convert.ToBoolean(ds.Tables[0].Rows[i]["Calendar"]);
_obj_Smhr_Category.CATEGORY_LOCALISATION = Convert.ToBoolean(ds.Tables[0].Rows[i]["Localisation"]);
_obj_Smhr_Category.CREATEDBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Category.CREATEDDATE = DateTime.Now;
_obj_Smhr_Category.LASTMDFBY = Convert.ToInt32(Session["USER_ID"]); // ### Need to Get the Session
_obj_Smhr_Category.LASTMDFDATE = DateTime.Now;
_obj_Smhr_Category.ORGANISATION_ID = Convert.ToInt32(Session["ORG_ID"]);
_obj_Smhr_Category.OPERATION = operation.Insert;
status = BLL.set_Category(_obj_Smhr_Category);
if (status == true)
{
BLL.ShowMessage(this, "Information Saved Successfully");
}
////else
//// BLL.ShowMessage(this, "Information Not Saved");
}
LoadGrid();
Rg_Categories.DataBind();
}
}
catch (Exception ex)
{
SMHR.BLL.Error_Log(Session["USER_ID"].ToString(), ex.TargetSite.ToString(), ex.Message.Replace("'", "''"), "frm_Catagory", ex.StackTrace, DateTime.Now);
Response.Redirect("~/Frm_ErrorPage.aspx");
}
}