public static List <DC_ProductList_Detail> GetAllDC_ProductList_Detail_CallActivities( )
{
string PROCEDURE = "p_SelectDC_ProductList_Detail_CallActivities";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new DC_ProductList_Detail
{
ProductListName = row["ProductListName"].ToString(),
MSIN = row["MSIN"].ToString(),
Price = long.Parse(row["Price"].ToString()),
Installment = ParseMonth(row["Meta"].ToString()),
SMSCode = row["SMSCode"].ToString(),
Name = row["Name"].ToString(),
}).ToList());
}
private static object GetParam_database(string ParamID, string Header)
{
string PROCEDURE = "p_SelectGetParamInvoice";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ParamID";
parameters[i].Value = ParamID;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ParamHeader";
parameters[i].Value = Header + DateTime.Now.ToString("yyMMdd");
i++;
return(SqlHelperAsync.ExecuteScalar(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters));
}
public static List <Deca_Position> GetAllDeca_Positions()
{
string PROCEDURE = "p_SelectDeca_PositionsAll";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new Deca_Position
{
PositionID = Convert.ToInt32(row["PositionID"].ToString()),
PositionName = row["PositionName"].ToString(),
Active = Convert.ToBoolean(row["Active"].ToString()),
CreatedDatetime = Convert.ToDateTime(row["CreatedDatetime"].ToString()),
CreatedUser = row["CreatedUser"].ToString(),
LastUpdatedDateTime = Convert.ToDateTime(row["LastUpdatedDateTime"].ToString()),
LastUpdatedUser = row["LastUpdatedUser"].ToString()
}).ToList());
}
public static Bank GetBankName(string BankName)
{
string PROCEDURE = "p_SelectBankName";
SqlParameter[] parameters = new SqlParameter[1];
parameters[0] = new SqlParameter();
parameters[0].ParameterName = "@BankName";
parameters[0].Value = BankName;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters);
return(dt.AsEnumerable().Select(row => new Bank
{
BankID = row["BankID"].ToString(),
BankName = row["BankName"].ToString()
}).ToList().FirstOrDefault());
}
public static List <Bank> GetAllBanks_isActive()
{
string PROCEDURE = "p_SelectBanksAll_isActive";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new Bank
{
BankID = row["BankID"].ToString(),
BankName = row["BankName"].ToString(),
Active = Convert.ToBoolean(row["Active"].ToString()),
CreatedDatetime = Convert.ToDateTime(row["CreatedDatetime"].ToString()),
CreatedUser = row["CreatedUser"].ToString(),
LastUpdatedDateTime = Convert.ToDateTime(row["LastUpdatedDateTime"].ToString()),
LastUpdatedUser = row["LastUpdatedUser"].ToString()
}).ToList());
}
public int Update_Done()
{
string PROCEDURE = "p_UpdateDC_Tele_Sales_History_Done";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowID";
parameters[i].Value = this.RowID;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowCreatedUser";
parameters[i].Value = this.RowCreatedUser;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, System.Data.CommandType.Text, PROCEDURE, parameters));
}
//public static List<Deca_RT_RoleUpdate> GetDeca_RT_RoleUpdates(string whereCondition, string orderByExpression)
//{
// string PROCEDURE = "p_SelectDeca_RT_RoleUpdatesDynamic";
// SqlParameter[] parameters = new SqlParameter[2];
// int i = 0;
// parameters[i] = new SqlParameter();
// parameters[i].ParameterName = "@WhereCondition";
// parameters[i].Value = whereCondition;
// i++;
// parameters[i] = new SqlParameter();
// parameters[i].ParameterName = "@OrderByExpression";
// parameters[i].Value = orderByExpression;
// DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters);
// return dt.AsEnumerable().Select(row => new Deca_RT_RoleUpdate
// {
// UserName = Convert.ToInt32(row["UserID"].ToString()),
// RowID = Convert.ToInt32(row["RowID"].ToString()),
// RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
// RowCreatedUser = row["RowCreatedUser"].ToString(),
// RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
// RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString()
// }).ToList();
//}
public static List <Deca_RT_RoleUpdate> GetAllDeca_RT_RoleUpdates()
{
string PROCEDURE = "p_SelectDeca_RT_RoleUpdatesAll";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new Deca_RT_RoleUpdate
{
UserID = row["UserID"].ToString(),
RowID = Convert.ToInt32(row["RowID"].ToString()),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString(),
UserName = row["UserName"].ToString(),
}).ToList());
}
public static List <DC_Customer_Resigned_Activity_Meta> GetAllDC_Customer_Resigned_Activity_Metas()
{
string PROCEDURE = "p_SelectDC_Customer_Resigned_Activity_MetasAll";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new DC_Customer_Resigned_Activity_Meta
{
RowID = Convert.ToInt32(row["RowID"].ToString()),
Factor = row["Factor"].ToString(),
Value = row["Value"].ToString(),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString()
}).ToList());
}
public int Update()
{
string PROCEDURE = "p_UpdateDC_NumberNetwork";
SqlParameter[] parameters = new SqlParameter[9];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ID";
parameters[i].Value = this._id;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ID_Network";
parameters[i].Value = this._id_network;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Number";
parameters[i].Value = this._number;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Active";
parameters[i].Value = this._active;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Type";
parameters[i].Value = this._type;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@CreatedDatetime";
parameters[i].Value = this._createddatetime;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@CreatedUser";
parameters[i].Value = this._createduser;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@LastUpdatedDateTime";
parameters[i].Value = this._lastupdateddatetime;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@LastUpdatedUser";
parameters[i].Value = this._lastupdateduser;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters));
}
public static DataSourceResult GetAllDC_Tele_Sales_Historys_ManageCallBack(string where, [DataSourceRequest] DataSourceRequest request)
{
string PROCEDURE = "p_SelectManageCallback";
var from1 = (request.Page - 1) * request.PageSize + 1;
var to = (request.Page - 1) * request.PageSize + request.PageSize;
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@where";
parameters[i].Value = where;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@WhereCondition1";
parameters[i].Value = "RowNum BETWEEN " + from1 + " AND " + to;
i++;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, System.Data.CommandType.Text, PROCEDURE, parameters);
var data = new DataSourceResult();
data.Data = dt.AsEnumerable().Select(row => new DC_Tele_Sales_History
{
RowCreatedUser = row["RowCreatedUser"].ToString(),
Note = row["Note"].ToString(),
CustomerID = row["CustomerID"].ToString(),
FullName = row["FullName"].ToString(),
MobilePhone = row["MobilePhone"].ToString(),
RecallDate = Convert.ToDateTime(row["RecallDate"].ToString()),
CallTime = Convert.ToDateTime(row["CallTime"].ToString()),
//Inbound = Convert.ToBoolean(row["Inbound"].ToString()),
//Source = row["Source"].ToString(),
//IsDone = row["IsDone"].ToString(),
RowID = Convert.ToInt32(row["RowID"].ToString()),
OrganizationID = row["OrganizationID"].ToString(),
ResultID = row["Description"].ToString(),
}).ToList();
var total = dt.AsEnumerable().Select(row => new DW_SMSMO
{
TotalRows = Int32.Parse(row["TotalRows"].ToString())
}).ToList().FirstOrDefault();
data.Total = total != null ? total.TotalRows : 0;
return(data);
}
public static List <DC_Tracking_Order> GetAllDC_Tracking_Orders_History(string ID)
{
string PROCEDURE = "p_SelectDC_Tracking_Order_History";
SqlParameter[] parameters = new SqlParameter[1];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ID";
parameters[i].Value = ID;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters);
return(dt.AsEnumerable().Select(row => new DC_Tracking_Order
{
ID = row["ID"].ToString(),
OrderID = row["OrderID"].ToString(),
MSIN = row["MSIN"].ToString(),
Status = row["Status"].ToString(),
Reason = row["Reason"].ToString(),
ReasonName = row["ReasonName"].ToString(),
Note = row["Note"].ToString(),
RowID = Convert.ToInt32(row["RowID"].ToString()),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString(),
LastActivities = row["LastActivities"].ToString(),
LastActivitiesStatus = row["LastActivitiesStatus"].ToString(),
Fee = Double.Parse(row["Fee"].ToString()),
ItemName = row["ItemName"].ToString(),
Amount = Convert.ToDouble(row["Amount"].ToString()),
OrderDate = Convert.ToDateTime(row["OrderDate"].ToString()),
UpdateDate = Convert.ToDateTime(row["UpdateDate"].ToString()),
OrderStatus = row["OrderStatus"].ToString(),
OrderStatusColor = row["OrderStatusColor"].ToString(),
Customer = row["Customer"].ToString(),
OrganizationID = row["OrganizationID"].ToString(),
ColorDay = row["ColorDay"].ToString(),
Email = row["Email"].ToString(),
Duration = row["Duration"].ToString(),
Department = row["Department"].ToString(),
}).ToList());
}
public static List <DC_Customer_Resigned> GetReportActiveBadDebt(DateTime FromDate, DateTime ToDate)
{
string PROCEDURE = "p_GetReportActiveBadDebt";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@FromDate";
parameters[i].Value = FromDate;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ToDate";
parameters[i].Value = ToDate;
i++;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters);
return(dt.AsEnumerable().Select(row => new DC_Customer_Resigned
{
OrganizationID = row["OrganizationID"].ToString(),
CustomerID = row["CustomerID"].ToString(),
ResignedReason = row["ResignedReason"].ToString(),
FullName = row["FullName"].ToString(),
MobilePhone = row["MobilePhone"].ToString(),
SettledBalance = Convert.ToDouble(row["SettledBalance"].ToString()),
PD = Convert.ToDateTime(row["PD"].ToString()),
BaselineSettledBalance = Convert.ToDouble(row["BaselineSettledBalance"].ToString()),
DurationDebt = Convert.ToInt32(row["DurationDebt"].ToString()),
ActionStatus = row["ActionStatus"].ToString(),
ActionCode = row["ActionCode"].ToString(),
Note = row["Note"].ToString(),
ContactMode = row["ContactMode"].ToString(),
BaselineSettledAmount = row["BaselineSettledAmount"].ToString(),
Money = row["Money"].ToString(),
PaymentDate = Convert.ToDateTime(row["PaymentDate"].ToString()),
Bank = row["Bank"].ToString(),
CollectionNotes = row["CollectionNotes"].ToString(),
BD = row["BD"].ToString(),
BDE = row["BDE"].ToString(),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
}).ToList());
}
public int Save()
{
string PROCEDURE = "p_SaveDC_Ticket_Holiday";
SqlParameter[] parameters = new SqlParameter[9];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Name";
parameters[i].Value = this.Name;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Description";
parameters[i].Value = this.Description;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Note";
parameters[i].Value = this.Note;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@StartDate";
parameters[i].Value = this.StartDate;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@EndDate";
parameters[i].Value = this.EndDate;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Department";
parameters[i].Value = this.Department;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Status";
parameters[i].Value = this.Status;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowCreatedTime";
parameters[i].Value = this.RowCreatedTime;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowCreatedUser";
parameters[i].Value = this.RowCreatedUser;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, System.Data.CommandType.Text, PROCEDURE, parameters));
}
public int Save()
{
string PROCEDURE = "p_SaveDC_Potential_Customer";
SqlParameter[] parameters = new SqlParameter[9];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@OrganizationID";
parameters[i].Value = this._organizationid;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@EmployeeID";
parameters[i].Value = this._employeeid;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@FullName";
parameters[i].Value = this._fullname;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@IndentityNumber";
parameters[i].Value = this._indentitynumber != null ? this.IndentityNumber : "";
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Phone";
parameters[i].Value = this._phone != null ? this._phone : "";
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@XMLString";
parameters[i].Value = this._xmlstring != null ? this._xmlstring : "";
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Active";
parameters[i].Value = this._active;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowCreatedTime";
parameters[i].Value = this._rowcreatedtime;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowCreatedUser";
parameters[i].Value = this._rowcreateduser;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters));
}
public static DC_Potential_Customer GetLoadSuggestDC_Potential_Customers(string OrganizationID, string EmployeeID, string Phone, string IndentityNumber, string FullName)
{
EmployeeID = string.IsNullOrEmpty(EmployeeID) ? "N'%%'" : "N'" + EmployeeID + "'";
Phone = string.IsNullOrEmpty(Phone) ? "N'%%'" : "N'" + Phone + "'";
IndentityNumber = string.IsNullOrEmpty(IndentityNumber) ? "N'%%'" : "N'" + IndentityNumber + "'";
FullName = string.IsNullOrEmpty(FullName) ? "N'%%'" : "N'" + FullName + "'";
string PROCEDURE = "EXEC [p_Select_DC_Potential_Customer_Load_Suggest] @OrganizationID = '" + OrganizationID + "'," +
" @Phone = " + Phone + ",@EmployeeID= " + EmployeeID + ",@FullName= " + FullName + ",@IndentityNumber= " + IndentityNumber;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.Text, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new DC_Potential_Customer
{
OrganizationID = row["OrganizationID"].ToString(),
EmployeeID = string.IsNullOrEmpty(row["OrgEmployeeID"].ToString()) ? row["EmployeeID"].ToString() : row["OrgEmployeeID"].ToString(),
FullName = row["FullName"].ToString(),
IndentityNumber = row["IndentityNumber"].ToString(),
Phone = row["Phone"].ToString(),
Active = Convert.ToBoolean(row["Active"].ToString()),
RowID = Convert.ToInt32(row["RowID"].ToString()),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString(),
Salary = double.Parse(row["Salary"].ToString()),
Position = row["Position"].ToString(),
Title = row["Title"].ToString(),
Sex = row["Sex"].ToString(),
Department = row["Department"].ToString(),
ContractType = row["ContractType"].ToString(),
Address = row["Address"].ToString(),
Email = row["Email"].ToString(),
Blacklist = bool.Parse(row["Blacklist"].ToString()),
ContractExp = Convert.ToDateTime(row["ContractExp"].ToString()),
Birthday = Convert.ToDateTime(row["Birthday"].ToString()),
StartWorkDate = Convert.ToDateTime(row["StartWorkDate"].ToString()),
CIFbank = row["CIFbank"].ToString(),
Note = row["Note"].ToString(),
DC_ID = row["DC_ID"].ToString(),
OrgEmployeeID = row["OrgEmployeeID"].ToString() != "" ? row["OrgEmployeeID"].ToString() : row["EmployeeID"].ToString(),
DC_EmployeeID = row["DC_EmployeeID"].ToString()
}).ToList().FirstOrDefault());
}
public int Save()
{
string PROCEDURE = "p_SaveDC_HomeNetwork";
SqlParameter[] parameters = new SqlParameter[9];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ID";
parameters[i].Value = this._id;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@NetworkName";
parameters[i].Value = this._networkname;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Decription";
parameters[i].Value = this._decription;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Active";
parameters[i].Value = this._active;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@CreatedDatetime";
parameters[i].Value = this._createddatetime;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@CreatedUser";
parameters[i].Value = this._createduser;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@LastUpdatedDateTime";
parameters[i].Value = this._lastupdateddatetime;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@LastUpdatedUser";
parameters[i].Value = this._lastupdateduser;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ValidText";
parameters[i].Value = this._validtext;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters));
}
public int Update()
{
string PROCEDURE = "p_UpdateCRM_Ticket_Queue";
SqlParameter[] parameters = new SqlParameter[9];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@QueueID";
parameters[i].Value = this.QueueID;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@QueueName";
parameters[i].Value = this.QueueName;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Description";
parameters[i].Value = this.Description;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Department";
parameters[i].Value = this.Department;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Team";
parameters[i].Value = this.Team;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@User";
parameters[i].Value = this.User;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Status";
parameters[i].Value = this.Status;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowLastUpdatedTime";
parameters[i].Value = this.RowLastUpdatedTime;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@RowLastUpdatedUser";
parameters[i].Value = this.RowLastUpdatedUser;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters));
}
public static DC_TeleSale_History_CallResult GetDC_TeleSale_History_CallResult_CountCustomer(string user)
{
string PROCEDURE = "p_SelectDC_TeleSale_History_CallResult_CountCustomer";
SqlParameter[] parameters = new SqlParameter[1];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@user";
parameters[i].Value = user;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters);
return(dt.AsEnumerable().Select(row => new DC_TeleSale_History_CallResult
{
CountRemider = int.Parse(row["CountRemider"].ToString())
}).ToList().FirstOrDefault());
}
public int Delete()
{
string PROCEDURE = "p_DeleteDC_Tele_Hint_Meta";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ArticleID";
parameters[i].Value = ArticleID;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@Factor";
parameters[i].Value = Factor;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, System.Data.CommandType.StoredProcedure, PROCEDURE, parameters));
}
public static List <DC_CheckList_ApplyFor> GetAllDC_CheckList_Definition_Orgs()
{
string PROCEDURE = "p_SelectDC_CheckList_Definition_OrgsAll";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new DC_CheckList_ApplyFor
{
ChecklistSubID = row["ChecklistSubID"].ToString(),
ChecklistID = row["ChecklistID"].ToString(),
OrganizationID = row["OrganizationID"].ToString(),
RowID = Convert.ToInt32(row["RowID"].ToString()),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString()
}).ToList());
}
public int Delete()
{
string PROCEDURE = "p_DeleteUserInOrg";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@UserID";
parameters[i].Value = this._userid;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@OrgID";
parameters[i].Value = this._orgid;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters));
}
public static List <DC_Customer_Group> GetAllDC_Customer_Groups()
{
string PROCEDURE = "p_SelectDC_Customer_GroupsAll";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, System.Data.CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new DC_Customer_Group
{
CustomerID = row["CustomerID"].ToString(),
GroupID = row["GroupID"].ToString(),
Active = Convert.ToBoolean(row["Active"].ToString()),
RowID = Convert.ToInt32(row["RowID"].ToString()),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString()
}).ToList());
}
public static List <CRM_Ticket_Type> GetListAssignee(string typeid)
{
string PROCEDURE = "p_SelectCRM_Ticket_Type_GetListAssignee";
SqlParameter[] parameters = new SqlParameter[1];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@TypeID";
parameters[i].Value = typeid;
i++;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters);
return(dt.AsEnumerable().Select(row => new CRM_Ticket_Type
{
Name = row["UserName"].ToString(),
}).ToList());
}
public static List <Deca_Business_Unit_Department> GetAllDeca_Business_Unit_Departments()
{
string PROCEDURE = "p_SelectDeca_Business_Unit_DepartmentsAll";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new Deca_Business_Unit_Department
{
BusinessID = row["BusinessID"].ToString(),
DepartmentID = row["DepartmentID"].ToString(),
Active = Convert.ToBoolean(row["Active"].ToString()),
RowID = Convert.ToInt32(row["RowID"].ToString()),
RowCreatedTime = Convert.ToDateTime(row["RowCreatedTime"].ToString()),
RowCreatedUser = row["RowCreatedUser"].ToString(),
RowLastUpdatedTime = Convert.ToDateTime(row["RowLastUpdatedTime"].ToString()),
RowLastUpdatedUser = row["RowLastUpdatedUser"].ToString()
}).ToList());
}
public static int AutoDone(string CustomerID, string UserID)
{
string PROCEDURE = "p_UpdateDC_Tele_Sales_Histories_AutoDone";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@CustomerID";
parameters[i].Value = CustomerID;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@UserID";
parameters[i].Value = UserID;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, System.Data.CommandType.Text, PROCEDURE, parameters));
}
public static List <DC_GetCustomerResignedList> CheckBaselineSettledBalance(string CustomerID)
{
string procedure = "p_CheckBaselineSettledBalance";
SqlParameter[] parameters = new SqlParameter[1];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@CustomerID";
parameters[i].Value = CustomerID;
i++;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, procedure, parameters);
return(dt.AsEnumerable().Select(row => new DC_GetCustomerResignedList
{
CustomerID = row["CustomerID"].ToString(),
}).ToList());
}
public int Delete()
{
string PROCEDURE = "p_DeleteDC_Customer_Resigned_Activity";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@CustomerID";
parameters[i].Value = this._customerid;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@ActionStatus";
parameters[i].Value = this._actionstatus;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, parameters));
}
public static List <CRM_Department> GetAllCRM_Departments()
{
string PROCEDURE = "p_SelectCRM_DepartmentsAll";
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.StoredProcedure, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new CRM_Department
{
DepartmentID = Convert.ToInt32(row["DepartmentID"].ToString()),
Department = row["Department"].ToString(),
Active = Convert.ToBoolean(row["Active"].ToString()),
CreatedDatetime = Convert.ToDateTime(row["CreatedDatetime"].ToString()),
CreatedUser = row["CreatedUser"].ToString(),
LastUpdatedDateTime = Convert.ToDateTime(row["LastUpdatedDateTime"].ToString()),
LastUpdatedUser = row["LastUpdatedUser"].ToString(),
Manager = row["MANAGER"].ToString()
}).ToList());
}
public int InsertQueue(string QueueID)
{
string PROCEDURE = "insert into CRM_Ticket_Type_Queue(TypeID, QueueID) values(@TypeID, @QueueID)";
SqlParameter[] parameters = new SqlParameter[2];
int i = 0;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@TypeID";
parameters[i].Value = this.TypeID;
i++;
parameters[i] = new SqlParameter();
parameters[i].ParameterName = "@QueueID";
parameters[i].Value = QueueID;
i++;
return(SqlHelperAsync.ExecuteNonQuery(Constants.AllConstants().CONNECTION_STRING, CommandType.Text, PROCEDURE, parameters));
}
public static List <DW_DC_Order_Item> GetSuggestDC_OrderItemListForGird(string OrganizationID, string CustomerID, string FullName, string Phone, string OrderID)
{
CustomerID = string.IsNullOrEmpty(CustomerID) ? "N'%%'" : "N'%" + CustomerID + "%'";
FullName = string.IsNullOrEmpty(FullName) ? "N'%%'" : "N'%" + FullName + "%'";
Phone = string.IsNullOrEmpty(Phone) ? "N'%%'" : "N'%" + Phone + "%'";
OrderID = string.IsNullOrEmpty(OrderID) ? "N'%%'" : "N'%" + OrderID + "%'";
string PROCEDURE = "EXEC [p_Select_DC_OrderItem_Suggest]@OrganizationID = '" + OrganizationID + "'," + " @CustomerID = " + CustomerID + ",@MobilePhone = " + Phone + ",@OrderID = " + OrderID + ",@FullName = " + FullName;
DataTable dt = SqlHelperAsync.ExecuteDataTable(Constants.AllConstants().CONNECTION_STRING, CommandType.Text, PROCEDURE, null);
return(dt.AsEnumerable().Select(row => new DW_DC_Order_Item
{
OrderID = row["OrderID"].ToString(),
Status = row["Status"].ToString()
}).ToList());
}
