private MaterialInModel _DataBind(int Code)
{
MaterialInModel model = new MaterialInModel();
StringBuilder builder = new StringBuilder();
builder.Append("select * from V_MaterialIn as MaterialIn ");
builder.Append(" where MaterialInCode=@MaterialInCode");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@MaterialInCode", SqlDbType.Int, 4, Code);
SqlDataReader sqlDataReader = null;
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
this.Initialize(sqlDataReader, model);
}
}
catch (SqlException exception)
{
throw exception;
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(model);
}
private int _Insert(MaterialInModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("insert into MaterialIn(");
builder.Append("MaterialInCode, MaterialInID,ProjectCode,GroupCode,InDate,InPerson,Status,InputPerson,InputDate,CheckPerson,CheckDate,ContractCode,Remark)");
builder.Append(" values (");
builder.Append("@MaterialInCode, @MaterialInID,@ProjectCode,@GroupCode,@InDate,@InPerson,@Status,@InputPerson,@InputDate,@CheckPerson,@CheckDate,@ContractCode,@Remark) ");
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.ProcessParametersAdd("@MaterialInCode", SqlDbType.Int, 4, mObj.MaterialInCode);
this._DataProcess.ProcessParametersAdd("@MaterialInID", SqlDbType.VarChar, 50, mObj.MaterialInID);
this._DataProcess.ProcessParametersAdd("@ProjectCode", SqlDbType.VarChar, 50, (mObj.ProjectCode == null) ? "" : mObj.ProjectCode);
this._DataProcess.ProcessParametersAdd("@GroupCode", SqlDbType.VarChar, 50, mObj.GroupCode);
this._DataProcess.ProcessParametersAdd("@InDate", SqlDbType.DateTime, 8, mObj.InDate);
this._DataProcess.ProcessParametersAdd("@InPerson", SqlDbType.VarChar, 50, mObj.InPerson);
this._DataProcess.ProcessParametersAdd("@Status", SqlDbType.Int, 4, mObj.Status);
this._DataProcess.ProcessParametersAdd("@InputPerson", SqlDbType.VarChar, 50, mObj.InputPerson);
this._DataProcess.ProcessParametersAdd("@InputDate", SqlDbType.DateTime, 8, mObj.InputDate);
this._DataProcess.ProcessParametersAdd("@CheckPerson", SqlDbType.VarChar, 50, mObj.CheckPerson);
this._DataProcess.ProcessParametersAdd("@CheckDate", SqlDbType.DateTime, 8, mObj.CheckDate);
this._DataProcess.ProcessParametersAdd("@ContractCode", SqlDbType.VarChar, 50, mObj.ContractCode);
this._DataProcess.ProcessParametersAdd("@Remark", SqlDbType.VarChar, 800, mObj.Remark);
this._DataProcess.RunSql();
return(mObj.MaterialInCode);
}
public int Update(MaterialInModel ObjModel)
{
int num = 0;
using (SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString()))
{
connection.Open();
SqlTransaction transaction = connection.BeginTransaction();
try
{
num = new MaterialInBLL().Update(ObjModel, transaction);
transaction.Commit();
return(num);
}
catch (SqlException exception)
{
transaction.Rollback();
connection.Close();
throw exception;
}
finally
{
connection.Close();
}
}
return(num);
}
public int Update(MaterialInModel ObjModel, SqlTransaction Transaction)
{
MaterialInDAL ndal = new MaterialInDAL(Transaction);
ObjModel.InputDate = DateTime.Now;
return(ndal.Update(ObjModel));
}
private List <MaterialInModel> _Select(MaterialInQueryModel qmObj)
{
List <MaterialInModel> list = new List <MaterialInModel>();
StringBuilder builder = new StringBuilder();
builder.Append("select * from V_MaterialIn as MaterialIn ");
builder.Append(qmObj.QueryConditionStr);
if ((qmObj.SortColumns == null) || (qmObj.SortColumns.Length == 0))
{
builder.Append(" ORDER BY MaterialInCode desc");
}
else
{
builder.Append(" ORDER BY " + qmObj.SortColumns);
}
this._DataProcess.CommandText = builder.ToString();
this._DataProcess.SqlParameters = qmObj.Parameters;
SqlDataReader sqlDataReader = null;
int num = 0;
try
{
sqlDataReader = this._DataProcess.GetSqlDataReader();
while (sqlDataReader.Read())
{
if ((num >= qmObj.StartRecord) && ((list.Count < qmObj.MaxRecords) || (qmObj.MaxRecords == -1)))
{
MaterialInModel model = new MaterialInModel();
this.Initialize(sqlDataReader, model);
list.Add(model);
}
num++;
}
}
catch (SqlException exception)
{
throw exception;
}
finally
{
if (sqlDataReader != null)
{
sqlDataReader.Close();
}
}
return(list);
}
public ActionResult MaterialInDataEditView(int MaterialInId)
{
GetMaterialInPurchaserList();
MaterialInModel model = new MaterialInModel();
MaterialIn newFitCat = db.MaterialIns.Where(a => a.MaterialInId.Equals(MaterialInId)).FirstOrDefault();
if (newFitCat != null)
{
model.MatInPurchaserId = newFitCat.MatInPurchaserId;
model.PurchaseItem = newFitCat.PurchaseItem;
model.Quantity = newFitCat.Quantity;
model.Rate = newFitCat.Rate;
model.Quality = newFitCat.Quality;
model.Size = newFitCat.Size;
model.Cartridge = newFitCat.Cartridge;
}
return(View("MaterialInDataSetup", model));
}
public ActionResult MaterialInDataSetup(MaterialInModel model)
{
System.Random random = new System.Random();
MaterialIn materialInData = db.MaterialIns.Where(a => a.MaterialInId.Equals(model.MaterialInId)).FirstOrDefault();
if (materialInData == null)
{
MaterialIn newMaterialInDataadd = new MaterialIn();
newMaterialInDataadd.MaterialInNo = "MatNo_" + random.Next();
newMaterialInDataadd.MatInPurchaserId = model.MatInPurchaserId;
newMaterialInDataadd.PurchaseItem = model.PurchaseItem;
newMaterialInDataadd.Quantity = model.Quantity;
newMaterialInDataadd.Rate = model.Rate;
newMaterialInDataadd.IsDebit = true;
newMaterialInDataadd.IsCredit = false;
newMaterialInDataadd.Quality = model.Quality;
newMaterialInDataadd.Size = model.Size;
newMaterialInDataadd.Cartridge = model.Cartridge;
newMaterialInDataadd.CreateDate = DateTime.Now;
newMaterialInDataadd.IsActive = true;
db.MaterialIns.Add(newMaterialInDataadd);
db.SaveChanges();
ModelState.Clear();
model = null;
this.AddNotification("Thats great! Successfully Saved.", NotificationType.SUCCESS);
}
else
{
materialInData.MatInPurchaserId = model.MatInPurchaserId;
materialInData.PurchaseItem = model.PurchaseItem;
materialInData.Quantity = model.Quantity;
materialInData.Rate = model.Rate;
materialInData.Quality = model.Quality;
materialInData.Size = model.Size;
materialInData.Cartridge = model.Cartridge;
db.SaveChanges();
model = null;
this.AddNotification("Thats great! Successfully Edited.", NotificationType.SUCCESS);
}
return(RedirectToAction("MaterialInDataList"));
}
public MaterialInModel GetMaterialIn(int Code)
{
MaterialInModel model = new MaterialInModel();
SqlConnection connection = new SqlConnection(FunctionRule.GetConnectionString());
try
{
model = new MaterialInBLL().GetModel(Code, connection);
connection.Close();
}
catch (SqlException exception)
{
throw exception;
}
finally
{
if (connection != null)
{
connection.Dispose();
}
}
return(model);
}
public int Update(MaterialInModel mObj)
{
return(this._Update(mObj));
}
public int Insert(MaterialInModel mObj)
{
return(this._Insert(mObj));
}
private void Initialize(SqlDataReader reader, MaterialInModel obj)
{
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode")) != DBNull.Value)
{
obj.MaterialInCode = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID")) != DBNull.Value)
{
obj.MaterialInID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "MaterialInID"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode")) != DBNull.Value)
{
obj.ProjectCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ProjectCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode")) != DBNull.Value)
{
obj.GroupCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "GroupCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InDate")) != DBNull.Value)
{
obj.InDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InDate"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPerson")) != DBNull.Value)
{
obj.InPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InPerson"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Status")) != DBNull.Value)
{
obj.Status = reader.GetInt32(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Status"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputPerson")) != DBNull.Value)
{
obj.InputPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputPerson"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputDate")) != DBNull.Value)
{
obj.InputDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "InputDate"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckPerson")) != DBNull.Value)
{
obj.CheckPerson = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckPerson"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckDate")) != DBNull.Value)
{
obj.CheckDate = reader.GetDateTime(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "CheckDate"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode")) != DBNull.Value)
{
obj.ContractCode = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractCode"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Remark")) != DBNull.Value)
{
obj.Remark = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "Remark"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractID")) != DBNull.Value)
{
obj.ContractID = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractID"));
}
if (reader.GetValue(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractName")) != DBNull.Value)
{
obj.ContractName = reader.GetString(SqlDataProcess.GetSqlDataReaderFieldIndex(reader, "ContractName"));
}
}
public int Delete(MaterialInModel mObj)
{
return(this._Delete(mObj.MaterialInCode));
}
private int _Update(MaterialInModel mObj)
{
StringBuilder builder = new StringBuilder();
builder.Append("update MaterialIn set ");
if (mObj.MaterialInID != null)
{
builder.Append("MaterialInID=@MaterialInID,");
this._DataProcess.ProcessParametersAdd("@MaterialInID", SqlDbType.VarChar, 50, mObj.MaterialInID);
}
if (mObj.ProjectCode != null)
{
builder.Append("ProjectCode=@ProjectCode,");
this._DataProcess.ProcessParametersAdd("@ProjectCode", SqlDbType.VarChar, 50, mObj.ProjectCode);
}
if (mObj.GroupCode != null)
{
builder.Append("GroupCode=@GroupCode,");
this._DataProcess.ProcessParametersAdd("@GroupCode", SqlDbType.VarChar, 50, mObj.GroupCode);
}
if (mObj.InDate != DateTime.MinValue)
{
builder.Append("InDate=@InDate,");
this._DataProcess.ProcessParametersAdd("@InDate", SqlDbType.DateTime, 8, mObj.InDate);
}
if (mObj.InPerson != null)
{
builder.Append("InPerson=@InPerson,");
this._DataProcess.ProcessParametersAdd("@InPerson", SqlDbType.VarChar, 50, mObj.InPerson);
}
if (mObj.Status != 0)
{
builder.Append("Status=@Status,");
this._DataProcess.ProcessParametersAdd("@Status", SqlDbType.Int, 4, mObj.Status);
}
if (mObj.InputPerson != null)
{
builder.Append("InputPerson=@InputPerson,");
this._DataProcess.ProcessParametersAdd("@InputPerson", SqlDbType.VarChar, 50, mObj.InputPerson);
}
if (mObj.InputDate != DateTime.MinValue)
{
builder.Append("InputDate=@InputDate,");
this._DataProcess.ProcessParametersAdd("@InputDate", SqlDbType.DateTime, 8, mObj.InputDate);
}
if (mObj.CheckPerson != null)
{
builder.Append("CheckPerson=@CheckPerson,");
this._DataProcess.ProcessParametersAdd("@CheckPerson", SqlDbType.VarChar, 50, mObj.CheckPerson);
}
if (mObj.CheckDate != DateTime.MinValue)
{
builder.Append("CheckDate=@CheckDate,");
this._DataProcess.ProcessParametersAdd("@CheckDate", SqlDbType.DateTime, 8, mObj.CheckDate);
}
if (mObj.ContractCode != null)
{
builder.Append("ContractCode=@ContractCode,");
this._DataProcess.ProcessParametersAdd("@ContractCode", SqlDbType.VarChar, 50, mObj.ContractCode);
}
if (mObj.Remark != null)
{
builder.Append("Remark=@Remark,");
this._DataProcess.ProcessParametersAdd("@Remark", SqlDbType.VarChar, 800, mObj.Remark);
}
builder.Remove(builder.Length - 1, 1);
builder.Append(" where MaterialInCode=@MaterialInCode");
this._DataProcess.ProcessParametersAdd("@MaterialInCode", SqlDbType.Int, 4, mObj.MaterialInCode);
this._DataProcess.CommandText = builder.ToString();
return(this._DataProcess.RunSql());
}
public int Delete(MaterialInModel ObjModel, SqlTransaction Transaction)
{
return(this.Delete(ObjModel.MaterialInCode, Transaction));
}
