public bool InsertMappedRegions(DataTable dtRegCodes, string UserName)
{
bool result = false;
try
{
SqlCommand command = new SqlCommand("SP_HD_InsertMappedRegion");
command.CommandType = CommandType.StoredProcedure;
//using (IDbConnection connection = IDbOpenConnection())
//{
// var p = new DynamicParameters();
// p.Add("@UserName", UserName);
// result=connection.Execute(SP_HD_InsertMappedRegion, p, commandType: CommandType.StoredProcedure);
// connection.Close();
//}
if (dtRegCodes.Rows.Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_DCRStatus_RegionCodes", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_DCRStatus_RegionCodes");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_DCRStatus_RegionCodes", ParameterDirection.Input, SqlDbType.Structured, dtRegCodes, "TVP_DCRStatus_RegionCodes");
}
_objData.OpenConnection();
_objData.ExecuteNonQuery(command);
result = true;
}
catch (Exception ex)
{
throw;
}
return(result);
}
public bool InsertMasterData(DataTable dtUserCodes)
{
bool result = false;
try
{
SqlCommand command = new SqlCommand("SP_HD_InsertMasterData");
command.CommandType = CommandType.StoredProcedure;
if (dtUserCodes.Rows.Count == 0)
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_MasterData_Details", ParameterDirection.Input, SqlDbType.Structured, null, "TVP_MasterData_Details");
}
else
{
_objSPData.AddParamToSqlCommandWithTypeName(command, "@TVP_MasterData_Details", ParameterDirection.Input, SqlDbType.Structured, dtUserCodes, "TVP_MasterData_Details");
}
_objData.OpenConnection();
_objData.ExecuteNonQuery(command);
result = true;
}
catch (Exception ex)
{
throw;
}
return(result);
}
public bool InsertUserSession()
{
DataControl.Data objData = new DataControl.Data();
try
{
string macId = GetMACInformation();
string ipAddress = Request.ServerVariables["REMOTE_ADDR"].ToString();
string browserName = Request.Browser.Browser + " " + Request.Browser.MajorVersion.ToString() + "." + Request.Browser.MinorVersion.ToString();
string companyCode = _objCurInfo.GetCompanyCode();
string userCode = _objCurInfo.GetUserCode();
string userName = _objCurInfo.GetUserName();
string sessionId = _objCurInfo.GetSessionId();
string latitude = _objCurInfo.GetLattitude();
string longitude = _objCurInfo.GetLongitude();
string location = _objCurInfo.GetLocation();
string loginTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss:fff");
bool isTrue = false;
objData.OpenConnection(_objCurInfo.GetCompanyCode());
{
objData.ExecuteNonQuery("exec sp_sdInsertUserSession '" + _objCurInfo.GetCompanyCode() + "','" + _objCurInfo.GetUserCode() + "','" + _objCurInfo.GetUserName() + "','" + _objCurInfo.GetSessionId() + "','" + loginTime + "','" + ipAddress + "','" + macId + "','" + browserName + "','" + latitude + "','" + longitude + "','" + location + "'");
}
return(isTrue);
}
finally
{
objData.CloseConnection();
}
}
public int InsertSplashScreenData(string companyCode, SplashScreenModel objSplashScreenModel)
{
int result = 0;
try
{
SqlCommand command = new SqlCommand(SP_SC_INSERT_SPLASH_SCREEN_DATA);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
_objSPData.AddParamToSqlCommand(command, "@Splash_Type", ParameterDirection.Input, SqlDbType.VarChar, 150, objSplashScreenModel.Splash_Type);
_objSPData.AddParamToSqlCommand(command, "@Title", ParameterDirection.Input, SqlDbType.VarChar, 150, objSplashScreenModel.Title);
_objSPData.AddParamToSqlCommand(command, "@Description", ParameterDirection.Input, SqlDbType.VarChar, 1000, objSplashScreenModel.Description);
_objSPData.AddParamToSqlCommand(command, "@File_Path", ParameterDirection.Input, SqlDbType.VarChar, 250, objSplashScreenModel.File_Path);
_objSPData.AddParamToSqlCommand(command, "@Date_From", ParameterDirection.Input, SqlDbType.Date, 30, objSplashScreenModel.Date_From);
_objSPData.AddParamToSqlCommand(command, "@Date_To", ParameterDirection.Input, SqlDbType.Date, 30, objSplashScreenModel.Date_To);
_objSPData.AddParamToSqlCommand(command, "@Has_Attachment", ParameterDirection.Input, SqlDbType.Int, 4, objSplashScreenModel.Has_Attachment);
_objSPData.AddParamToSqlCommand(command, "@Mobile_Attachment_Url", ParameterDirection.Input, SqlDbType.VarChar, 250, objSplashScreenModel.Mobile_Attachment_Url);
_objSPData.AddParamToSqlCommand(command, "@Assigned_To_All_Users", ParameterDirection.Input, SqlDbType.Int, 4, objSplashScreenModel.Assigned_To_All_Users);
_objSPData.AddParamToSqlCommand(command, "@Is_Completed", ParameterDirection.Input, SqlDbType.Int, 4, objSplashScreenModel.Is_Completed);
_objSPData.AddParamToSqlCommand(command, "@Last_Modified_DateTime", ParameterDirection.Input, SqlDbType.DateTime, 20, objSplashScreenModel.Last_Modified_DateTime);
_objSPData.AddParamToSqlCommand(command, "@Description_HTML", ParameterDirection.Input, SqlDbType.VarChar, -1, objSplashScreenModel.Description_HTML);
SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.Int);
returnValue.Direction = ParameterDirection.Output;
returnValue.Size = 500;
returnValue.Value = "";
command.Parameters.Add(returnValue);
_objData.OpenConnection(companyCode);
_objData.ExecuteNonQuery(command);
result = Convert.ToInt32(returnValue.Value);
return(result);
}
catch (Exception ex)
{
throw ex;
}
finally
{
_objData.CloseConnection();
}
}
//RegionWeekendGroupMapping
public string RegionWeekendGroupMapping(string weekendoffCode, string regionCodes, string effectiveFrom, string effectiveTo, string status)
{
SPData _objSPData = new SPData();
string companyCode = _objCurInfo.GetCompanyCode();
string result = "";
try
{
SqlCommand command = new SqlCommand(SP_HDWEEKENDGROUPREGIONMAPPING);
command.CommandType = CommandType.StoredProcedure;
_objSPData.AddParamToSqlCommand(command, "@CompanyCode", ParameterDirection.Input, SqlDbType.VarChar, 30, _objCurInfo.GetCompanyCode());
_objSPData.AddParamToSqlCommand(command, "@WeekendOffCode", ParameterDirection.Input, SqlDbType.VarChar, 30, weekendoffCode);
_objSPData.AddParamToSqlCommand(command, "@RegionCodes", ParameterDirection.Input, SqlDbType.VarChar, regionCodes.Length, regionCodes);
_objSPData.AddParamToSqlCommand(command, "@EffectiveFrom", ParameterDirection.Input, SqlDbType.VarChar, 30, effectiveFrom);
_objSPData.AddParamToSqlCommand(command, "@EffectiveTo", ParameterDirection.Input, SqlDbType.VarChar, 30, effectiveTo);
_objSPData.AddParamToSqlCommand(command, "@Status", ParameterDirection.Input, SqlDbType.Char, 1, status);
SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar);
returnValue.Direction = ParameterDirection.Output;
returnValue.Size = 500;
returnValue.Value = "";
command.Parameters.Add(returnValue);
_objData.OpenConnection(companyCode);
_objData.ExecuteNonQuery(command);
result = returnValue.Value.ToString();
return(result);
}
catch (Exception ex)
{
return("FAILURE:");
}
finally
{
_objData.CloseConnection();
}
}
public string ExpenseInsert(string storedProcedure, string expensetypeCode, string companyCode, string expensetypeName, string expensetypeStatus, string expenseMode,
string Period, string Mode, string displayOrder)
{
try
{
DataControl.CurrentInfo objCurentInfo = new DataControl.CurrentInfo();
//string conStr = objData.GetConnectionString(objCurentInfo.GetCompanyCode());
//con.ConnectionString = conStr;
DataControl.Data db = new DataControl.Data();
// Command - specify as StoredProcedure
SqlCommand command = new SqlCommand(storedProcedure, con);
command.CommandType = CommandType.StoredProcedure;
AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
AddParamToSqlCommand(command, "@Expense_Type_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, expensetypeCode);
AddParamToSqlCommand(command, "@Expense_Type_Name", ParameterDirection.Input, SqlDbType.VarChar, 50, expensetypeName);
AddParamToSqlCommand(command, "@Expense_Type_Status", ParameterDirection.Input, SqlDbType.VarChar, 30, expensetypeStatus);
AddParamToSqlCommand(command, "@Expense_Mode", ParameterDirection.Input, SqlDbType.VarChar, 30, expenseMode);
AddParamToSqlCommand(command, "@Expense_Period", ParameterDirection.Input, SqlDbType.VarChar, 30, Period);
AddParamToSqlCommand(command, "@Mode", ParameterDirection.Input, SqlDbType.VarChar, 30, Mode);
AddParamToSqlCommand(command, "@DisplayOrder", ParameterDirection.Input, SqlDbType.VarChar, 30, displayOrder);
// Return value as parameter
SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar);
returnValue.Direction = ParameterDirection.Output;
returnValue.Size = 500;
command.Parameters.Add(returnValue);
if (db.OpenConnection(objCurentInfo.GetCompanyCode()))
{
// Execute the stored procedure
db.ExecuteNonQuery(command);
db.CloseConnection();
}
//For Handle the Error
return(returnValue.Value.ToString());
}
catch (Exception ex)
{
ErrorLog.LogError(ex, "ExpenseInsert()");
return("ERROR");
}
}
public string Inward(string storedProcedure, string companyCode, string UserCode, string ProductCode, string InwardDate, string Inwardstock, string UserInwardCode, string UserInwarddetails, string CurrentStock)
{
try
{
DataControl.CurrentInfo objCurentInfo = new DataControl.CurrentInfo();
//string conStr = objData.GetConnectionString(objCurentInfo.GetCompanyCode());
//con.ConnectionString = conStr;
DataControl.Data db = new DataControl.Data();
// Command - specify as StoredProcedure
SqlCommand command = new SqlCommand(storedProcedure, con);
command.CommandType = CommandType.StoredProcedure;
AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
AddParamToSqlCommand(command, "@User_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, UserCode);
AddParamToSqlCommand(command, "@Product_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, ProductCode);
AddParamToSqlCommand(command, "@Inward_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, InwardDate);
AddParamToSqlCommand(command, "@Inward_stock", ParameterDirection.Input, SqlDbType.VarChar, 30, Inwardstock);
AddParamToSqlCommand(command, "@User_Inward_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, UserInwardCode);
AddParamToSqlCommand(command, "@User_Inward_Detail", ParameterDirection.Input, SqlDbType.VarChar, 30, UserInwarddetails);
AddParamToSqlCommand(command, "@Current_Stock", ParameterDirection.Input, SqlDbType.VarChar, 30, CurrentStock);
// Return value as parameter
SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar);
returnValue.Direction = ParameterDirection.Output;
returnValue.Size = 500;
command.Parameters.Add(returnValue);
if (db.OpenConnection(objCurentInfo.GetCompanyCode()))
{
// Execute the stored procedure
db.ExecuteNonQuery(command);
db.CloseConnection();
}
//For Handle the Error
return(returnValue.Value.ToString());
}
catch (Exception ex)
{
ErrorLog.LogError(ex, "Inward()");
return("ERROR");
}
}
public string productInsert(string storedProcedure, string companyCode, string salesproductCode, string mappingproductCode, string effectiveFrom, string createdDate, string createdBy, string recordStatus)
{
try
{
DataControl.CurrentInfo objCurentInfo = new DataControl.CurrentInfo();
//string conStr = objData.GetConnectionString(objCurentInfo.GetCompanyCode());
//con.ConnectionString = conStr;
DataControl.Data db = new DataControl.Data();
// Command - specify as StoredProcedure
SqlCommand command = new SqlCommand(storedProcedure, con);
command.CommandType = CommandType.StoredProcedure;
AddParamToSqlCommand(command, "@Company_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, companyCode);
AddParamToSqlCommand(command, "@Sales_Product_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, salesproductCode);
AddParamToSqlCommand(command, "@Mapping_Product_Code", ParameterDirection.Input, SqlDbType.VarChar, 30, mappingproductCode);
AddParamToSqlCommand(command, "@Effective_From", ParameterDirection.Input, SqlDbType.VarChar, 30, effectiveFrom);
AddParamToSqlCommand(command, "@Created_Date", ParameterDirection.Input, SqlDbType.VarChar, 30, createdDate);
AddParamToSqlCommand(command, "@Created_By", ParameterDirection.Input, SqlDbType.VarChar, 30, createdBy);
AddParamToSqlCommand(command, "@Record_Status", ParameterDirection.Input, SqlDbType.VarChar, 1, recordStatus);
// Return value as parameter
SqlParameter returnValue = new SqlParameter("@Result", SqlDbType.VarChar);
returnValue.Direction = ParameterDirection.Output;
returnValue.Size = 500;
command.Parameters.Add(returnValue);
if (db.OpenConnection(objCurentInfo.GetCompanyCode()))
{
// Execute the stored procedure
db.ExecuteNonQuery(command);
db.CloseConnection();
}
//For Handle the Error
return(returnValue.Value.ToString());
}
catch (Exception ex)
{
ErrorLog.LogError(ex, "productInsert()");
return("ERROR");
}
}
