public static bool ChangeCustomerPassword(string OldPassword, string NewPassword, int CustomerId)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "ChangeCustomerPassword";
// create a new parameter
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@OldPassword";
param1.Value = OldPassword;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
DbParameter param2 = comm.CreateParameter();
param2.ParameterName = "@NewPassword";
param2.Value = NewPassword;
param2.DbType = DbType.String;
comm.Parameters.Add(param2);
DbParameter param3 = comm.CreateParameter();
param3.ParameterName = "@CustomerId";
param3.Value = CustomerId;
param3.DbType = DbType.Int32;
comm.Parameters.Add(param3);
if (gda.ExecuteNonQuery(comm) > 0)
{
return(true);
}
else
{
return(false);
}
}
public SavingState UpdateUser(User objUser)
{
SavingState svState = SavingState.Failed;
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
thisCommand.CommandText = "UPDATE IM_USERS SET USER_NAME=@USER_NAME, PASSWORD=@PASSWORD, ACTIVE=@ACTIVE WHERE USER_ID=@USER_ID";
CreateParameter.AddParam(thisCommand, "@USER_ID", objUser.userID, DbType.String);
CreateParameter.AddParam(thisCommand, "@USER_NAME", objUser.userName, DbType.String);
CreateParameter.AddParam(thisCommand, "@PASSWORD", objUser.password, DbType.String);
CreateParameter.AddParam(thisCommand, "@ACTIVE", objUser.active, DbType.Boolean);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
return(svState);
}
public static bool UpdateCMS(string LinkName, string Desc, int CMSId)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "UpdateCMS";
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@LinkName";
param1.Value = LinkName;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
DbParameter param2 = comm.CreateParameter();
param2.ParameterName = "@Desc";
param2.Value = Desc;
param2.DbType = DbType.String;
comm.Parameters.Add(param2);
DbParameter param3 = comm.CreateParameter();
param3.ParameterName = "@CMSId";
param3.Value = CMSId;
param3.DbType = DbType.Int32;
comm.Parameters.Add(param3);
if (gda.ExecuteNonQuery(comm) > 0)
{
return(true);
}
else
{
return(false);
}
}
// Add a new shopping cart item
public static bool AddReview(string customerId, string productId, string review)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "CatalogAddProductReview ";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@CustomerID";
param.Value = customerId;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@ProductID";
param.Value = productId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Review";
param.Value = review;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// returns true in case of success or false in case of an error
try
{
// execute the stored procedure and return true if it executes
// successfully, or false otherwise
return(GenericDataAccess.ExecuteNonQuery(comm) != -1);
}
catch
{
// prevent the exception from propagating, but return false to
// signal the error
return(false);
}
}
/// <summary>
/// Insert or Update Student
/// </summary>
/// <param name="studentEntity">The Student Entity</param>
/// <returns> entity id</returns>
//public static int InsertUpdate(IStudentEntity studentEntity)
public static IStudentEntity InsertUpdate(IStudentEntity studentEntity)
{
try
{
using var comm = GenericDataAccess.CreateCommand(Connections.Configuration.StudentV4Db);
comm.CommandText = "Student_InsertUpdate";
comm.AddParamWithValue("@StudentId", DbType.Int32, studentEntity.StudentId);
comm.AddParamWithValue("@StudentName", DbType.String, studentEntity.StudentName);
comm.AddParamWithValue("@StudentRollNumber", DbType.String, studentEntity.StudentRollNumber);
comm.AddParamWithValue("@StudentFatherName", DbType.String, studentEntity.StudentFatherName);
comm.AddParamWithValue("@StudentMotherName", DbType.String, studentEntity.StudentMotherName);
var resu = GenericDataAccess.ExecuteNonQuery(comm);
studentEntity.StudentId = resu;
}
catch (Exception ex)
{
DataErrorLogger.LogError(ex);
throw ex;
}
return(studentEntity);
}
// move product to a new category
public static bool MoveProductToCategory(string productId, string oldCategoryId, string newCategoryId)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "MoveProductToCategory";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@ProductID";
param.Value = productId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@OldCategoryID";
param.Value = oldCategoryId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@NewCategoryID";
param.Value = newCategoryId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// result will represent the number of changed rows
int result = -1;
try
{
// execute the stored procedure
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
// any errors are logged in GenericDataAccess, we ingore them here
}
// result will be 1 in case of success
return (result != -1);
}
//绑定授权登录新用户//
public static bool OAuthBoundNew(int userId, string userName, string userPassword)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "OAuthBoundNew_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = userId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserName";
param.Value = userName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserPassword";
param.Value = userPassword;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return(result != -1);
}
public static bool UpdateCMS(int id, string IpAddress, string Status)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "UpdateWhitelistIps";
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@Id";
param1.Value = id;
param1.DbType = DbType.Int32;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@IpAddress";
param1.Value = IpAddress;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@status";
param1.Value = Status;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
if (gda.ExecuteNonQuery(comm) > 0)
{
return(true);
}
else
{
return(false);
}
}
public static void UpdateOrderStatus(int orderID, int status)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "CommerceLibOrderUpdateStatus";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@OrderID";
param.Value = orderID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Status";
param.Value = status;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// execute the stored procedure
GenericDataAccess.ExecuteNonQuery(comm);
}
//修改同步授权登录//
public static bool SyncUpdateOAuth(OAuthEntity oAuth)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "SyncUpdateOAuth_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = oAuth.User.UserID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@OpenID";
param.Value = oAuth.OpenID;
param.DbType = DbType.String;
param.Size = 100;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@OAuthBound";
param.Value = oAuth.OAuthBound;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return(result != -1);
}
public static bool CheckAdminExist(string EmailId, int AdminId)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "CheckAdminExist";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@EmailId";
param.Value = EmailId;
param.DbType = DbType.String;
comm.Parameters.Add(param);
DbParameter param2 = comm.CreateParameter();
param2.ParameterName = "@AdminId";
param2.Value = AdminId;
param2.DbType = DbType.Int32;
comm.Parameters.Add(param2);
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@Flag";
param1.Direction = ParameterDirection.Output;
param1.DbType = DbType.Boolean;
comm.Parameters.Add(param1);
// return the result table
int n = gda.ExecuteNonQuery(comm);
return(Convert.ToBoolean(comm.Parameters["@Flag"].Value));
}
// Add a new department
public static bool AddDepartment(string name, string description)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "CatalogAddDepartment";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@DepartmentName";
param.Value = name;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@DepartmentDescription";
param.Value = description;
param.DbType = DbType.String;
param.Size = 1000;
comm.Parameters.Add(param);
// result will represent the number of changed rows
int result = -1;
try
{
// execute the stored procedure
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
// any errors are logged in GenericDataAccess, we ignore them here
}
// result will be 1 in case of success
return(result != -1);
}
//删除用户//
public static bool DeleteUser(int userId)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "DeleteUser_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = userId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return(result != -1);
}
public SavingState DeductAllDamagedItemsStockOfCompany(string companyId)
{
SavingState svState = SavingState.Failed;
DbCommand comm = null;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = "UPDATE IM_Items_Stock SET DamagedStock = @DamagedStock WHERE ItemId IN (SELECT ItemId FROM IM_Items WHERE CompanyId = @CompanyId)";
CreateParameter.AddParam(comm, "@DamagedStock", 0, DbType.Int32);
CreateParameter.AddParam(comm, "@CompanyId", companyId, DbType.String);
GenericDataAccess.ExecuteNonQuery(comm);
comm.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(svState);
}
public SavingState DeductItemsStock(int stockNeedToDeduct, string stockId)
{
SavingState svState = SavingState.Failed;
DbCommand comm = null;
try
{
comm = GenericDataAccess.CreateCommand();
comm.CommandType = CommandType.Text;
comm.CommandText = "UPDATE IM_Items_Stock SET TotalStock = @TotalStock WHERE StockId = @StockId";
CreateParameter.AddParam(comm, "@TotalStock", stockNeedToDeduct, DbType.String);
CreateParameter.AddParam(comm, "@StockId", stockId, DbType.String);
GenericDataAccess.ExecuteNonQuery(comm);
comm.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (comm != null && comm.Connection.State != ConnectionState.Closed)
{
comm.Connection.Close();
}
}
return(svState);
}
public static bool UpdateAppointment(string appointmentid, string customername, string customerphonenumber, string customeremailaddress, string customerzipcode, string appdate, string apptime, string status, string CarPlate, string CarValuation, int locationID)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "UpdateApointment";
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@AppointmentId";
param1.Value = appointmentid;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@CustomerName";
param1.Value = customername;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@CustomerPhoneNumber";
param1.Value = customerphonenumber;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@CustomerEmailAddress";
param1.Value = customeremailaddress;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@CustomerZipCode";
param1.Value = customerzipcode;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@AppointmentDate";
param1.Value = appdate;
param1.DbType = DbType.DateTime;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@AppointmentTime";
param1.Value = apptime;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@CarPlate";
param1.Value = CarPlate;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@status";
param1.Value = status;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@CarValuation";
param1.Value = CarValuation;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@locationID";
param1.Value = locationID;
param1.DbType = DbType.Int16;
comm.Parameters.Add(param1);
if (gda.ExecuteNonQuery(comm) > 0)
{
return(true);
}
else
{
return(false);
}
}
//更新用户资料//
public static bool UpdateUser(UserEntity user)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "UpdateUser_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = user.UserID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserName";
param.Value = user.UserName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserPassword";
param.Value = user.UserPassword;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserNickName";
param.Value = user.UserNickName;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserImage";
param.Value = user.UserImage;
param.DbType = DbType.String;
param.Size = 200;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserEmail";
param.Value = user.UserEmail;
param.DbType = DbType.String;
param.Size = 100;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserPhone";
param.Value = user.UserPhone;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserTheme";
param.Value = user.UserTheme;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserLevel";
param.Value = user.UserLevel;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserFrom";
param.Value = user.UserFrom;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserCity";
param.Value = user.UserCity;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserMoney";
param.Value = user.UserMoney;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserWorkDay";
param.Value = user.UserWorkDay;
param.DbType = DbType.String;
param.Size = 2;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryRate";
param.Value = user.CategoryRate;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Synchronize";
param.Value = user.Synchronize;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return(result != -1);
}
//注册新用户，输出用户ID用于登录//
public static bool InsertUser(UserEntity user, out int userId)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "InsertUser_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@UserName";
param.Value = user.UserName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserPassword";
param.Value = user.UserPassword;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserNickName";
param.Value = user.UserNickName;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserImage";
param.Value = user.UserImage;
param.DbType = DbType.String;
param.Size = 200;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserEmail";
param.Value = user.UserEmail;
param.DbType = DbType.String;
param.Size = 100;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserPhone";
param.Value = user.UserPhone;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserTheme";
param.Value = user.UserTheme;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserFrom";
param.Value = user.UserFrom;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserWorkDay";
param.Value = user.UserWorkDay;
param.DbType = DbType.String;
param.Size = 2;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserMoney";
param.Value = user.UserMoney;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryRate";
param.Value = user.CategoryRate;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Direction = ParameterDirection.Output;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
userId = 0;
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
userId = Int32.Parse(comm.Parameters["@UserID"].Value.ToString());
}
catch
{
}
return(userId != 0);
}
//This method updates author information using the "UpdateAuthor" stored procedure. The names of the method parameters should match the names of the fields in the corresponding data control (e.g. Gridview, Detailsview, etc.)
//The method returns an int representing the number of rows affected. This can be used to verify a successful operation, or it can be discarded
public static int UpdateAuthor(string au_id, string au_lname, string au_fname, string phone, string address, string city, string state, string zip, bool contract)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "UpdateAuthor"; //This is the name of the stored procedure to be executed
//The following code adds the neccessary parameters to the DbCommand object
DbParameter param = comm.CreateParameter();
param.ParameterName = "@au_id";
param.DbType = DbType.String;
param.Value = au_id;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@au_lname";
param.DbType = DbType.String;
param.Value = au_lname;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@au_fname";
param.DbType = DbType.String;
param.Value = au_fname;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@phone";
param.DbType = DbType.String;
param.Value = phone;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@address";
param.DbType = DbType.String;
param.Value = address;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@city";
param.DbType = DbType.String;
param.Value = city;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@state";
param.DbType = DbType.String;
param.Value = state;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@zip";
param.DbType = DbType.String;
param.Value = zip;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@contract";
param.DbType = DbType.Byte;
param.Value = contract;
comm.Parameters.Add(param);
int rowsAffected = GenericDataAccess.ExecuteNonQuery(comm);
return(rowsAffected);
}
// Update an order
public static void Update(Order orderInfo)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "OrderUpdate";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@OrderId";
param.Value = orderInfo.Id;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@DateCreated";
param.Value = orderInfo.DateCreated;
param.DbType = DbType.DateTime;
comm.Parameters.Add(param);
// The DateShipped parameter is sent only if data is available
if (orderInfo.DateShipped.Trim() != "")
{
param = comm.CreateParameter();
param.ParameterName = "@DateShipped";
param.Value = orderInfo.DateShipped;
param.DbType = DbType.DateTime;
comm.Parameters.Add(param);
}
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Verified";
param.Value = orderInfo.Verified;
param.DbType = DbType.Byte;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Completed";
param.Value = orderInfo.Completed;
param.DbType = DbType.Byte;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Canceled";
param.Value = orderInfo.Canceled;
param.DbType = DbType.Byte;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Comments";
param.Value = orderInfo.Comments;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@CustomerName";
param.Value = orderInfo.CustomerName;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@ShippingAddress";
param.Value = orderInfo.ShippingAddress;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@CustomerEmail";
param.Value = orderInfo.CustomerEmail;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// return the results
GenericDataAccess.ExecuteNonQuery(comm);
}
//注册授权登录新用户//
public static bool InsertOAuth(OAuthEntity oAuth)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "InsertOAuth_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@UserName";
param.Value = oAuth.User.UserName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserPassword";
param.Value = oAuth.User.UserPassword;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserNickName";
param.Value = oAuth.User.UserNickName;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserImage";
param.Value = oAuth.User.UserImage;
param.DbType = DbType.String;
param.Size = 200;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserTheme";
param.Value = oAuth.User.UserTheme;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserFrom";
param.Value = oAuth.User.UserFrom;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@OpenID";
param.Value = oAuth.OpenID;
param.DbType = DbType.String;
param.Size = 100;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@AccessToken";
param.Value = oAuth.AccessToken;
param.DbType = DbType.String;
param.Size = 100;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@OAuthFrom";
param.Value = oAuth.OAuthFrom;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@OAuthBound";
param.Value = oAuth.OAuthBound;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return(result != -1);
}
public static bool UpdateCustomer(string FirstName,
string LastName,
char Sex,
string EmailId,
string Password,
string BusinessName,
string BAddress1,
string BAddress2,
string BCountryName,
string BStateName,
string BCityName,
string BZip,
string BPhone,
string BFax,
string BContactPerson, int CustomerId)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "Customer_Update";
// create a new parameter
// create a new parameter
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@FirstName";
param1.Value = FirstName;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
DbParameter param2 = comm.CreateParameter();
param2.ParameterName = "@LastName";
param2.Value = LastName;
param2.DbType = DbType.String;
comm.Parameters.Add(param2);
DbParameter param0 = comm.CreateParameter();
param0.ParameterName = "@Sex";
param0.Value = Sex;
param0.DbType = DbType.String;
comm.Parameters.Add(param0);
DbParameter param4 = comm.CreateParameter();
param4.ParameterName = "@EmailId";
param4.Value = EmailId;
param4.DbType = DbType.String;
comm.Parameters.Add(param4);
DbParameter param5 = comm.CreateParameter();
param5.ParameterName = "@Password";
param5.Value = Password;
param5.DbType = DbType.String;
comm.Parameters.Add(param5);
DbParameter param8 = comm.CreateParameter();
param8.ParameterName = "@BAddress1";
param8.Value = BAddress1;
param8.DbType = DbType.String;
comm.Parameters.Add(param8);
DbParameter param9 = comm.CreateParameter();
param9.ParameterName = "@BAddress2";
param9.Value = BAddress2;
param9.DbType = DbType.String;
comm.Parameters.Add(param9);
DbParameter param10 = comm.CreateParameter();
param10.ParameterName = "@BCountryName";
param10.Value = BCountryName;
param10.DbType = DbType.String;
comm.Parameters.Add(param10);
DbParameter param11 = comm.CreateParameter();
param11.ParameterName = "@BStateName";
param11.Value = BStateName;
param11.DbType = DbType.String;
comm.Parameters.Add(param11);
DbParameter param12 = comm.CreateParameter();
param12.ParameterName = "@BCityName";
param12.Value = BCityName;
param12.DbType = DbType.String;
comm.Parameters.Add(param12);
DbParameter param13 = comm.CreateParameter();
param13.ParameterName = "@BZip";
param13.Value = BZip;
param13.DbType = DbType.String;
comm.Parameters.Add(param13);
DbParameter param14 = comm.CreateParameter();
param14.ParameterName = "@BPhone";
param14.Value = BPhone;
param14.DbType = DbType.String;
comm.Parameters.Add(param14);
DbParameter param15 = comm.CreateParameter();
param15.ParameterName = "@BusinessName";
param15.Value = BusinessName;
param15.DbType = DbType.String;
comm.Parameters.Add(param15);
DbParameter param16 = comm.CreateParameter();
param16.ParameterName = "@BContactPerson";
param16.Value = BContactPerson;
param16.DbType = DbType.String;
comm.Parameters.Add(param16);
DbParameter param17 = comm.CreateParameter();
param17.ParameterName = "@CustomerId";
param17.Value = CustomerId;
param17.DbType = DbType.String;
comm.Parameters.Add(param17);
DbParameter param18 = comm.CreateParameter();
param18.ParameterName = "@BFax";
param18.Value = BFax;
param18.DbType = DbType.String;
comm.Parameters.Add(param18);
if (gda.ExecuteNonQuery(comm) > 0)
{
return(true);
}
else
{
return(false);
}
}
public static Boolean InsertUpdateDeleteCarSourcing(string operationtype, int carsourcingid, string fullname, string postcode,
string phonenumber, string email, string cardetails, string approxbudget, string deposit, Boolean isactive, Boolean deletestatus)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "pcw_carsourcing";
// create a new parameter
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@operationtype";
param1.Value = operationtype;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@carsourcingid";
param1.Value = carsourcingid;
param1.DbType = DbType.Int16;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@fullname";
param1.Value = fullname;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@postcode";
param1.Value = postcode;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@phonenumber";
param1.Value = phonenumber;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@emailaddress";
param1.Value = email;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@cardetails";
param1.Value = cardetails;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@approxbudget";
param1.Value = approxbudget;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@deposit";
param1.Value = deposit;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@isactive";
param1.Value = isactive;
param1.DbType = DbType.Boolean;
comm.Parameters.Add(param1);
param1 = comm.CreateParameter();
param1.ParameterName = "@deletestatus";
param1.Value = deletestatus;
param1.DbType = DbType.Boolean;
comm.Parameters.Add(param1);
DbParameter param5 = comm.CreateParameter();
param5.ParameterName = "@ret";
param5.DbType = DbType.Int32;
param5.Direction = ParameterDirection.Output;
comm.Parameters.Add(param5);
// return the result table
if (gda.ExecuteNonQuery(comm) > 0)
{
return(true);
}
else
{
return(false);
}
}
public static bool InsertSupplier(string CompanyName, string Title, string FirstName, string LastName, decimal PhoneNo, decimal Fax,
string Email, string WebSite, string PaymentTerms, string BussinessAdd1,
string BussinessAdd2, int BussinessCity, int BussinessAState,
int BussinessCountry, string BussinessZip, string OtherAdd1, string OtherAdd2,
int OtherCity, int OtherAState, int OtherCountry, string OtherZip)
{
// get a configured DbCommand object
GenericDataAccess gda = new GenericDataAccess();
DbCommand comm = gda.CreateCommand();
// set the stored procedure name
comm.CommandText = "Supplier_Insert";
// create a new parameter
DbParameter param1 = comm.CreateParameter();
param1.ParameterName = "@CompanyName";
param1.Value = CompanyName;
param1.DbType = DbType.String;
comm.Parameters.Add(param1);
DbParameter param2 = comm.CreateParameter();
param2.ParameterName = "@Title";
param2.Value = Title;
param2.DbType = DbType.String;
comm.Parameters.Add(param2);
DbParameter param3 = comm.CreateParameter();
param3.ParameterName = "@FirstName";
param3.Value = FirstName;
param3.DbType = DbType.String;
comm.Parameters.Add(param3);
DbParameter param4 = comm.CreateParameter();
param4.ParameterName = "@LastName";
param4.Value = LastName;
param4.DbType = DbType.String;
comm.Parameters.Add(param4);
DbParameter param5 = comm.CreateParameter();
param5.ParameterName = "@PhoneNo";
param5.Value = PhoneNo;
param5.DbType = DbType.Decimal;
comm.Parameters.Add(param5);
DbParameter param6 = comm.CreateParameter();
param6.ParameterName = "@Fax";
param6.Value = Fax;
param6.DbType = DbType.Decimal;
comm.Parameters.Add(param6);
DbParameter param7 = comm.CreateParameter();
param7.ParameterName = "@Email";
param7.Value = Email;
param7.DbType = DbType.String;
comm.Parameters.Add(param7);
DbParameter param8 = comm.CreateParameter();
param8.ParameterName = "@WebSite";
param8.Value = WebSite;
param8.DbType = DbType.String;
comm.Parameters.Add(param8);
DbParameter param9 = comm.CreateParameter();
param9.ParameterName = "@PaymentTerms";
param9.Value = PaymentTerms;
param9.DbType = DbType.String;
comm.Parameters.Add(param9);
DbParameter param10 = comm.CreateParameter();
param10.ParameterName = "@BussinessAdd1";
param10.Value = BussinessAdd1;
param10.DbType = DbType.String;
comm.Parameters.Add(param10);
DbParameter param11 = comm.CreateParameter();
param11.ParameterName = "@BussinessAdd2";
param11.Value = BussinessAdd2;
param11.DbType = DbType.String;
comm.Parameters.Add(param11);
DbParameter param12 = comm.CreateParameter();
param12.ParameterName = "@BussinessCity";
param12.Value = BussinessCity;
param12.DbType = DbType.Int32;
comm.Parameters.Add(param12);
DbParameter param13 = comm.CreateParameter();
param13.ParameterName = "@BussinessState";
param13.Value = BussinessAState;
param13.DbType = DbType.Int32;
comm.Parameters.Add(param13);
DbParameter param14 = comm.CreateParameter();
param14.ParameterName = "@BussinessCountry";
param14.Value = BussinessCountry;
param14.DbType = DbType.Int32;
comm.Parameters.Add(param14);
DbParameter param15 = comm.CreateParameter();
param15.ParameterName = "@BussinessZip";
param15.Value = BussinessZip;
param15.DbType = DbType.String;
comm.Parameters.Add(param15);
DbParameter param16 = comm.CreateParameter();
param16.ParameterName = "@OtherAdd1";
param16.Value = OtherAdd1;
param16.DbType = DbType.String;
comm.Parameters.Add(param16);
DbParameter param17 = comm.CreateParameter();
param17.ParameterName = "@OtherAdd2";
param17.Value = OtherAdd2;
param17.DbType = DbType.String;
comm.Parameters.Add(param17);
DbParameter param18 = comm.CreateParameter();
param18.ParameterName = "@OtherCity";
param18.Value = OtherCity;
param18.DbType = DbType.Int32;
comm.Parameters.Add(param18);
DbParameter param19 = comm.CreateParameter();
param19.ParameterName = "@OtherState";
param19.Value = OtherAState;
param19.DbType = DbType.Int32;
comm.Parameters.Add(param19);
DbParameter param20 = comm.CreateParameter();
param20.ParameterName = "@OtherCountry";
param20.Value = OtherCountry;
param20.DbType = DbType.Int32;
comm.Parameters.Add(param20);
DbParameter param21 = comm.CreateParameter();
param21.ParameterName = "@OtherZip";
param21.Value = OtherZip;
param21.DbType = DbType.String;
comm.Parameters.Add(param21);
int retval = gda.ExecuteNonQuery(comm);
if (retval > 0)
{
return(true);
}
else
{
return(false);
}
}
public SavingState SaveStockItem(ItemStock itemStock, DbCommand command = null, bool isTransection = false)
{
SavingState svState = SavingState.Failed;
if (!string.IsNullOrEmpty(itemStock.ItemId))
{
DbCommand thisCommand = null;
try
{
if (!isTransection)
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
}
else
{
thisCommand = command;
}
/// if new Item
if (string.IsNullOrEmpty(itemStock.StockId))
{
if (!isTransection)
{
if (!IsItemExistInStock(itemStock.ItemId))
{
thisCommand.CommandText = "INSERT INTO IM_Items_Stock (StockId, ItemId, TotalStock, DamagedStock, ChalanNo, StockEntryDate) VALUES(@StockId, @ItemId, @TotalStock, @DamagedStock, @ChalanNo, @StockEntryDate)";
CreateParameter.AddParam(thisCommand, "@StockId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
else
{
if (!IsItemExistInStock(itemStock.ItemId, thisCommand, isTransection))
{
thisCommand.CommandText = "INSERT INTO IM_Items_Stock (StockId, ItemId, TotalStock, DamagedStock, ChalanNo, StockEntryDate) VALUES(@StockId, @ItemId, @TotalStock, @DamagedStock, @ChalanNo, @StockEntryDate)";
CreateParameter.AddParam(thisCommand, "@StockId", Guid.NewGuid().ToString(), DbType.String);
}
else
{
return(SavingState.DuplicateExists);
}
}
}
else
{
thisCommand.CommandText = "UPDATE IM_Items_Stock SET TotalStock = @TotalStock, DamagedStock = @DamagedStock, ChalanNo = @ChalanNo, StockEntryDate = @StockEntryDate WHERE StockId = @StockId AND ItemId = @ItemId";
CreateParameter.AddParam(thisCommand, "@StockId", itemStock.StockId, DbType.String);
}
CreateParameter.AddParam(thisCommand, "@ItemId", itemStock.ItemId, DbType.String);
CreateParameter.AddParam(thisCommand, "@TotalStock", itemStock.CurrentStockTotal, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@DamagedStock", itemStock.CurrentDamagedStockTotal, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@ChalanNo", itemStock.ChalanNo, DbType.String);
CreateParameter.AddParam(thisCommand, "@StockEntryDate", itemStock.StockEntryDate.Date, DbType.Date);
if (!itemStock.StockEntryDate.Date.Equals(DateTime.MinValue))
{
if (isTransection)
{
GenericDataAccess.ExecuteNonQueryTransaction(thisCommand);
}
else
{
GenericDataAccess.ExecuteNonQuery(thisCommand);
}
}
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (!isTransection)
{
GenericDataAccess.CloseDBConnection(thisCommand);
}
}
}
return(svState);
}
// Create a new product
public static bool CreateProduct(string categoryId, string name, string description, string price, string image1FileName, string image2FileName, string onDepartmentPromotion, string onCatalogPromotion)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "CreateProduct";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@CategoryID";
param.Value = categoryId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@ProductName";
param.Value = name;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@ProductDescription";
param.Value = description;
param.DbType = DbType.AnsiString;
param.Size = 5000;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@ProductPrice";
param.Value = price;
param.DbType = DbType.Decimal;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Image1FileName";
param.Value = image1FileName;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Image2FileName";
param.Value = image2FileName;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@OnDepartmentPromotion";
param.Value = onDepartmentPromotion;
param.DbType = DbType.Boolean;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@OnCatalogPromotion";
param.Value = onCatalogPromotion;
param.DbType = DbType.Boolean;
comm.Parameters.Add(param);
// result will represent the number of changed rows
int result = -1;
try
{
// execute the stored procedure
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
// any errors are logged in GenericDataAccess, we ingore them here
}
// result will be 1 in case of success
return (result >= 1);
}
public WordSearchResult Save()
{
SqlCommand cmd = GenericDataAccess.CreateCommand(Database.Utility.ConnectionString);
SqlParameter idParam = new SqlParameter("@ID", SqlDbType.Int);
cmd.Parameters.Add(idParam);
if (ID != -1)
{
// This WordSearchResult already exists. We'll do an UPDATE.
cmd.CommandText = @"UPDATE " + DBTABLENAME + @"
SET Word = @Word,
AppearanceCount = @AppearanceCount,
OldestTweetDateTime = @OldestTweetDateTime,
NewestTweetDateTime = @NewestTweetDateTime,
SearchFailed = @SearchFailed,
SearchDateTime = @SearchDateTime
WHERE ID = @ID";
idParam.Value = ID;
}
else
{
// This WordSearchResult is new. We'll do an INSERT.
cmd.CommandText = @"INSERT INTO " + DBTABLENAME + @" (Word, AppearanceCount, OldestTweetDateTime, NewestTweetDateTime, SearchFailed, SearchDateTime)
VALUES (@Word, @AppearanceCount, @OldestTweetDateTime, @NewestTweetDateTime, @SearchFailed, @SearchDateTime)
SET @ID = SCOPE_IDENTITY()";
idParam.Direction = ParameterDirection.Output;
}
// Add any necessary parameters here
cmd.Parameters.AddWithValue("@Word", Word);
cmd.Parameters.AddWithValue("@AppearanceCount", AppearanceCount);
SqlParameter oldestTweetDateTimeParameter = new SqlParameter
{
ParameterName = "@OldestTweetDateTime"
};
if (OldestTweetDateTime != null)
{
oldestTweetDateTimeParameter.Value = OldestTweetDateTime.Value;
}
else
{
oldestTweetDateTimeParameter.Value = DBNull.Value;
}
cmd.Parameters.Add(oldestTweetDateTimeParameter);
SqlParameter newestTweetDateTimeParameter = new SqlParameter()
{
ParameterName = "@NewestTweetDateTime"
};
if (NewestTweetDateTime != null)
{
newestTweetDateTimeParameter.Value = NewestTweetDateTime.Value;
}
else
{
newestTweetDateTimeParameter.Value = DBNull.Value;
}
cmd.Parameters.Add(newestTweetDateTimeParameter);
cmd.Parameters.AddWithValue("@SearchFailed", SearchFailed);
cmd.Parameters.AddWithValue("@SearchDateTime", SearchDateTime);
try
{
int numRows = GenericDataAccess.ExecuteNonQuery(cmd);
if (numRows == 1)
{
if (ID == -1)
{
ID = (int)idParam.Value;
}
}
}
catch (System.Exception ex)
{
// TODO: Log
throw;
}
return(this);
}
public SavingState SaveUser(User objUser)
{
SavingState svState = SavingState.Failed;
if (objUser != null)
{
if (!IsUserExist(objUser.userName))
{
if (!IsUserIdExist(objUser.userID))
{
DbCommand thisCommand = null;
try
{
thisCommand = GenericDataAccess.CreateCommand();
thisCommand.CommandType = CommandType.Text;
thisCommand.CommandText = "INSERT INTO IM_USERS (USER_ID, USER_NAME, PASSWORD, CREATION_DATE, ROLE_TYPE, ACTIVE) VALUES(@USER_ID, @USER_NAME, @PASSWORD, @CREATION_DATE, @ROLE_TYPE, @ACTIVE)";
CreateParameter.AddParam(thisCommand, "@USER_ID", objUser.userID, DbType.String);
CreateParameter.AddParam(thisCommand, "@USER_NAME", objUser.userName, DbType.String);
CreateParameter.AddParam(thisCommand, "@PASSWORD", objUser.password, DbType.String);
CreateParameter.AddParam(thisCommand, "@CREATION_DATE", DateTime.Now, DbType.DateTime);
CreateParameter.AddParam(thisCommand, "@ROLE_TYPE", (int)objUser.roleType, DbType.Int32);
CreateParameter.AddParam(thisCommand, "@ACTIVE", objUser.active, DbType.Boolean);
GenericDataAccess.ExecuteNonQuery(thisCommand);
thisCommand.Parameters.Clear();
svState = SavingState.Success;
}
catch (Exception ex)
{
if (ex.Message.ToLower().Contains("duplicate key"))
{
svState = SavingState.DuplicateExists;
}
}
finally
{
if (thisCommand != null && thisCommand.Connection.State != ConnectionState.Closed)
{
thisCommand.Connection.Close();
}
}
}
else
{
svState = UpdateUser(objUser);
}
}
else
{
svState = SavingState.DuplicateExists;
}
}
else
{
svState = SavingState.Failed;
}
return(svState);
}
// Update an existing product
public static bool UpdateProduct(string productId, string name, string description, string price, string Thumbnail, string Image, string PromoDept, string PromoFront)
{
// get a configured DbCommand object
DbCommand comm = GenericDataAccess.CreateCommand();
// set the stored procedure name
comm.CommandText = "CatalogUpdateProduct";
// create a new parameter
DbParameter param = comm.CreateParameter();
param.ParameterName = "@ProductID";
param.Value = productId;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@ProductName";
param.Value = name;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@ProductDescription";
param.Value = description;
param.DbType = DbType.String;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Price";
param.Value = price;
param.DbType = DbType.Decimal;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Thumbnail";
param.Value = Thumbnail;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@Image";
param.Value = Image;
param.DbType = DbType.String;
param.Size = 50;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@PromoDept";
param.Value = PromoDept;
param.DbType = DbType.Boolean;
comm.Parameters.Add(param);
// create a new parameter
param = comm.CreateParameter();
param.ParameterName = "@PromoFront";
param.Value = PromoFront;
param.DbType = DbType.Boolean;
comm.Parameters.Add(param);
// result will represent the number of changed rows
int result = -1;
try
{
// execute the stored procedure
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
// any errors are logged in GenericDataAccess, we ignore them here
}
// result will be 1 in case of success
return(result != -1);
}
//更新消费商品//
public static bool UpdateItem(ItemEntity item, int type)
{
DbCommand comm = GenericDataAccess.CreateCommand();
comm.CommandText = "UpdateItem_v4";
DbParameter param = comm.CreateParameter();
param.ParameterName = "@ItemID";
param.Value = item.ItemID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@ItemType";
param.Value = item.ItemType;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@ItemName";
param.Value = item.ItemName;
param.DbType = DbType.String;
param.Size = 20;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CategoryTypeID";
param.Value = item.CategoryTypeID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@ItemPrice";
param.Value = item.ItemPrice;
param.DbType = DbType.Double;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@ItemBuyDate";
param.Value = item.ItemBuyDate;
param.DbType = DbType.DateTime;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@UserID";
param.Value = item.UserID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Recommend";
param.Value = item.Recommend;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Synchronize";
param.Value = item.Synchronize;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@ItemAppID";
param.Value = item.ItemAppID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@RegionID";
param.Value = item.RegionID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@RegionType";
param.Value = item.RegionType;
param.DbType = DbType.String;
param.Size = 10;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@ZhuanTiID";
param.Value = item.ZhuanTiID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@CardID";
param.Value = item.CardID;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
param = comm.CreateParameter();
param.ParameterName = "@Type";
param.Value = type;
param.DbType = DbType.Int32;
comm.Parameters.Add(param);
int result = -1;
try
{
result = GenericDataAccess.ExecuteNonQuery(comm);
}
catch
{
}
return(result != -1);
}