public int Insert(string code, string name, int numbercode) { if (string.IsNullOrEmpty(code)) { SetError(98, "Invalid currency code"); return(Error_Number); } if (string.IsNullOrEmpty(name)) { SetError(98, "Invalid currency name"); return(Error_Number); } if (numbercode == 0) { SetError(98, "Invalid currency number code"); return(Error_Number); } Currency_Info ccyInfo = new Currency_Info(); ccyInfo.Code = code; ccyInfo.Name = name; ccyInfo.NumberCode = numbercode; if (base.Insert(ccyInfo) != 0) { SetError(0, String.Empty); } else { SetError(99, Error_Message); } return(Error_Number); }
public static int Update(Currency_Info obj) { if (obj != null) { return(dal_ccy.Update(obj.Code, obj.Name, obj.NumberCode)); } else { throw new Exception(dal_ccy.Error_Message); } }
//********************************************************************************** public SqlCommand EditOneCurrency(Currency_Info objCurrency_Info) { SqlCommand command = new SqlCommand("Update Currency Set Code= @Code,Name= @Name, NumberCode = @NumberCode Where Code= @Code"); command.CommandType = CommandType.Text; command.Parameters.Add("@Code", SqlDbType.NVarChar, 3).Value = objCurrency_Info.Code; command.Parameters.Add("@Name", SqlDbType.NVarChar, 45).Value = objCurrency_Info.Name; command.Parameters.Add("@NumberCode", SqlDbType.Int).Value = objCurrency_Info.NumberCode; this.AddCommand(command); return(command); }
public SqlCommand CreateOneCurrency(Currency_Info objCurrency_Info) { SqlCommand command = new SqlCommand("insert into Currency(Code, Name, NumberCode) Values(@Code, @Name, @NumberCode)"); command.CommandType = CommandType.Text; command.Parameters.Add("@Code", SqlDbType.NVarChar, 3).Value = objCurrency_Info.Code; command.Parameters.Add("@Name", SqlDbType.NVarChar, 45).Value = objCurrency_Info.Name; command.Parameters.Add("@NumberCode", SqlDbType.Int).Value = objCurrency_Info.NumberCode; this.AddCommand(command); return(command); }
protected int Delete(Currency_Info obj) { if (obj == null) { throw new Exception("Invalid data input"); } _dalCcy.RemoveOneCurrency(obj.Code); if (_dalCcy.Execute()) { return(_dalCcy.LastRecordsEffected); } throw _dalCcy.GetException; }
protected int Insert(Currency_Info obj) { if (obj == null) { throw new Exception("Invalid data input"); } _dalCcy.CreateOneCurrency(obj); if (_dalCcy.Execute()) { return(_dalCcy.LastRecordsEffected); } throw _dalCcy.GetException; }
private Currency_Info GenerateObj(DataRow ordCurrency) { if (ordCurrency == null) { throw new Exception("Invalid data row"); } Currency_Info objCurrency_Info = new Currency_Info(); if (ordCurrency["Code"] != DBNull.Value) { objCurrency_Info.Code = Convert.ToString(ordCurrency["Code"]); } if (ordCurrency["Name"] != DBNull.Value) { objCurrency_Info.Name = Convert.ToString(ordCurrency["Name"]); } if (ordCurrency["NumberCode"] != DBNull.Value) { objCurrency_Info.NumberCode = Convert.ToInt32(ordCurrency["NumberCode"]); } return(objCurrency_Info); }
public int Delete(string code) { if (string.IsNullOrEmpty(code)) { SetError(98, "Invalid currency code"); return(Error_Number); } Currency_Info ccyInfo = base.GetCurrencyById(code); if (ccyInfo == null) { SetError(99, "Currency not find"); return(Error_Number); } if (base.Delete(ccyInfo) != 0) { SetError(0, String.Empty); } else { SetError(99, Error_Message); } return(Error_Number); }
public int Update(string code, string name, int numbercode) { if (string.IsNullOrEmpty(code)) { SetError(98, "Invalid currency code"); return(Error_Number); } if (string.IsNullOrEmpty(name)) { SetError(98, "Invalid currency name"); return(Error_Number); } if (numbercode == 0) { SetError(98, "Invalid currency number code"); return(Error_Number); } Currency_Info ccyInfo = base.GetCurrencyById(code); if (ccyInfo == null) { SetError(99, "Currency not find"); return(Error_Number); } ccyInfo.Name = name; ccyInfo.NumberCode = numbercode; if (base.Update(ccyInfo) != 0) { SetError(0, String.Empty); } else { SetError(99, Error_Message); } return(Error_Number); }