public string Get(PI_Master _PI_Master, string mode)
{
string result = string.Empty;
SqlDataReader reader = null;
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = @"Data Source=192.168.0.110;Initial Catalog=TTSHTemp;User ID=sa;Password=ROOT#123";
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.CommandText = "spPI_MasterDML";
sqlCmd.Connection = myConnection;
myConnection.Open();
sqlCmd.Parameters.Add("@StatementType", SqlDbType.VarChar);
sqlCmd.Parameters["@StatementType"].Value = mode;
sqlCmd.Parameters.Add("@i_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_ID"].Value = _PI_Master.i_ID;
if (mode.ToString() != "Delete")
{
sqlCmd.Parameters.Add("@i_Dept_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_Dept_ID"].Value = _PI_Master.i_Dept_ID;
sqlCmd.Parameters.Add("@s_Firstname", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Firstname"].Value = _PI_Master.s_Firstname;
sqlCmd.Parameters.Add("@s_Lastname", SqlDbType.VarChar);
sqlCmd.Parameters["@StatementType"].Value = _PI_Master.s_Lastname;
sqlCmd.Parameters.Add("@s_Email", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Email"].Value = _PI_Master.s_Email;
sqlCmd.Parameters.Add("@s_Phone_no", SqlDbType.VarChar);
sqlCmd.Parameters["@s_Phone_no"].Value = _PI_Master.s_Phone_no;
sqlCmd.Parameters.Add("@s_MCR_No", SqlDbType.VarChar);
sqlCmd.Parameters["@s_MCR_No"].Value = _PI_Master.s_MCR_No;
sqlCmd.Parameters.Add("@UserCID", SqlDbType.VarChar);
sqlCmd.Parameters["@UserCID"].Value = _PI_Master.s_CreatedBy_ID;
}
sqlCmd.Parameters.Add("@Ret_Parameter", SqlDbType.VarChar);
sqlCmd.Parameters["@Ret_Parameter"].Size = 500;
sqlCmd.Parameters["@Ret_Parameter"].Direction = ParameterDirection.Output;
sqlCmd.ExecuteNonQuery();
if (string.IsNullOrEmpty(sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString()))
{
result = "Success" + " | " + sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
}
else
{
result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
}
return result;
}
public PI_Master Get(int id)
{
string result = string.Empty;
SqlDataReader reader = null;
PI_Master mas = new PI_Master();
SqlConnection myConnection = new SqlConnection();
myConnection.ConnectionString = @"Data Source=192.168.0.110;Initial Catalog=TTSHTemp;User ID=sa;Password=ROOT#123";
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = System.Data.CommandType.StoredProcedure;
sqlCmd.CommandText = "spPI_MasterDML";
sqlCmd.Connection = myConnection;
myConnection.Open();
sqlCmd.Parameters.Add("@StatementType", SqlDbType.VarChar);
sqlCmd.Parameters["@StatementType"].Value = "Select";
sqlCmd.Parameters.Add("@i_ID", SqlDbType.Int);
sqlCmd.Parameters["@i_ID"].Value = id;
sqlCmd.Parameters.Add("@Ret_Parameter", SqlDbType.VarChar);
sqlCmd.Parameters["@Ret_Parameter"].Size = 500;
sqlCmd.Parameters["@Ret_Parameter"].Direction = ParameterDirection.Output;
reader =sqlCmd.ExecuteReader();
while (reader.Read())
{
mas.s_Email = reader.GetValue(4).ToString();
mas.s_Phone_no = reader.GetValue(5).ToString();
mas.s_MCR_No = reader.GetValue(6).ToString();
}
//if (string.IsNullOrEmpty(sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString()))
//{
// result = "Success" + " | " + sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
// mas.s_Email=
//}
//else
//{
// result = sqlCmd.Parameters[sqlCmd.Parameters.Count - 1].Value.ToString();
//}
return mas;
}